Kbase P20384: ADM2 - Possible Poor SDO Query Performance
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/03/2003 |
|
Status: Unverified
GOAL:
ADM2 - Possible Poor SDO Query Performance
FACT(s) (Environment):
Progress 9.0x
CAUSE:
In 9.0a setQuerywhere appended the where clause to the LAST table.
This may result in poor performance on a joined query.
FIX:
In 9.0b the addQuerywhere and assignQuerySelection functions were added
to allow more effective and flexible query manipulation.
The setQueryWhere was fixed to add the where clause to the first table referenced in the input parameter.