Use Nonequality Operators to Improve Performance

You can reduce the number of rules required by using the nonequality comparison operators to limit the size of the rules table, when possible. For example, if any shirt that is of length 40 or smaller receives a 10% discount, then you can set up a condition dimension for the Length attribute with greater than (>) operator to set up the price adjustment rule. For more information, see Adding Attribute Adjustment Conditions.

Caution: Make sure that the attribute adjustment is set up so that the attribute adjustment returns only one record. When nonequality operators are used, the attribute adjustment may return more than one record. Pricing administrators are responsible for setting up the dimensions in the appropriate way or setting up the pricing procedure to handle multiple matches.

Using wildcards does not improve performance, but it does decrease the number of records in the rules table.