Kbase P128008: 4GL/ABL: Can the FIND statement ever use more than one INDEX?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/01/2008 |
|
Status: Unverified
GOAL:
4GL/ABL: Can the FIND statement ever use more than one INDEX?
GOAL:
Can the FIND statement with a compound WHERE clause ever use more than one INDEX?
GOAL:
When does a compound WHERE clause cause Progress to use more than one index?
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
With the FIND statement, Progress never uses more than one INDEX. Even when the FIND statement has a compound WHERE clause with both sides of the AND are equality matches on indexed fields, only a single index is used.
With the FOR EACH statement with a compound WHERE clause, Progress builds a logic tree and evaluates index usage on either side of the AND. If both sides of the AND include equality matches on all components of non-unique indexes, both indexes are used.