Kbase P5715: How to improve nested FOR EACH query performance?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/06/2008 |
|
Status: Verified
GOAL:
How to improve nested FOR EACH query performance?
FACT(s) (Environment):
Progress 8.x
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
1)Review the use of indexes in the current query by using the COMPILE statement with the XREF option.
2) Review the query options by trying different queries using the ETIME function to measure relative performance in an environment that closely matches the expected deployment setting.
3) Modify the FOR EACH statements to use multiple brackets and indexes adding indexes if deemed better for the query performance.
4) Review the query optimization recommendations in the Progress Database Design Guide.