Kbase P26271: 4GL: How the MATCHES statement influences the index usage wh
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/2/2003 |
|
Status: Unverified
GOAL:
How the MATCHES statement influences the index usage when used in a composed WHERE clause?
GOAL:
MATCHES index usage.
FIX:
MATCHES does not use index information when performing a comparison; it always scans the entire data table. If MATCHES is used in a where clause using the AND operator:
WHERE (Condition 1) AND (condition 2 using MATCHES)
Then Progress optimizes the index usage by searching first for the records matching Condition 1 and then it scans the entire table of the first result in order to match also Condition 2 that contains the MATCHES statement.