Kbase P26465: Dynamic Query seems to hang with certain where clauses.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/06/2003 |
|
Status: Unverified
SYMPTOM(s):
Dynamic Query seems to hang with certain where clauses.
CAUSE:
Extensive use of MATCHES operator resulting in extremely long execution time of query.
Does not occur in all cases due to different query optimalizations in each case.
FIX:
Use a Word-indexes and the CONTAINS operator instead of the MATCHES operator. This will allow index usage and will greatly reduce execution time of the query.