Kbase P167323: If schema holder does not know about index defined in underlying oracle database, will a query use t
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/06/2010 |
|
Status: Verified
GOAL:
If schema holder does not know about index defined in underlying oracle database, will a query use that underlying index on oracle?
GOAL:
How does Oracle data server pick which index in Oracle database to use?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
Oracle DataServer generates index hints with index information retrieved from schema holder, therefore it is necessary to update schema holder when index in Oracle database changes.