Kbase 19166: CAPS Function in a Where Clause Does Not Use Index
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/1/1999 |
|
SUMMARY:
When using the CAPS function on the left side of the searchExpr in a WHERE clause, Progress does not use an index to resolve the query.
EXPLANATION:
The following code, written against the customer table of the sports
database, will not use the index (name) to resolve the query.
FOR EACH Customer WHERE CAPS(Name) BEGINS "A" NO-LOCK:
......
END.
The reason for this is because CAPS is not a Server-Evaluatable
Function and Progress is forced to send all the records to the client
to perform the selection criteria. This can cause slow query
performance.
References to Written Documentation:
Progress Database Design Guide