Kbase P20926: FIND against temp-table using multiple index fields is slow
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/01/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.X
SYMPTOM(s):
FIND against temp-table using multiple index fields is slow
FIND tt-batches WHERE tt-batches.dept_cd EQ batch_det.dept_cd
AND tt-batches.style_cd EQ batch_det.style_cd
AND tt-batches.colour_cd EQ batch_det.colour_cd
AND tt-batches.size_cd EQ batch_det.size_cd
AND tt-batches.batch_id EQ batch_det.batch_id is slow
FIX:
Optimize the query definition, eg find out what data are within tt-branches temp-table and how to set correct order for find, eg what fields have more changes than the others.
Example for this particular case:
FIND tt-batches WHERE tt-batches.style_cd EQ batch_det.style_cd
AND tt-batches.size_cd EQ batch_det.size_cd
AND tt-batches.colour_cd EQ batch_det.colour_cd
AND tt-batches.dept_cd EQ batch_det.dept_cd