Kbase 19509: ADM2 - Possible Poor SDO Query Performance in 9.0A
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/7/2000 |
|
In 9.0a setQuerywhere appended the where clause to the LAST table. This
may result in poor performance on a joined query.
In 9.0b we added the addQuerywhere and assignQuerySelection functions to allow for more effective and flexible query manipulation. We also fixed
setQueryWhere to add the where clause to the first table referenced in
the input parameter.