Performance of ordering on multi-predicate indexed queries
When performing a multiple predicate indexed query, for the best performance,
the predicates should be ordered so that the most restrictive predicate
is evaluated first. Predicates are evaluated from last to first (not the
intuitive evaluation order), so the most restrictive predicate should be
last in the query code.
For example, in the following query
(customer.status==#valid) & (customer.lastName=aName)}
The query predicate on lastName is performed first, resulting in a much
smaller set that the second predicate must perform the query over.
To avoid perturbing existing tuned queries, we will not be changing this.
Please examine your existing multi-term queries to ensure the ordering
is optional for performance.