Kbase P96665: SQL: How does the OpenEdge SQL Optimizer use INDEX hints?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/1/2010 |
|
Status: Unverified
GOAL:
SQL: How does the OpenEdge SQL Optimizer use INDEX hints?
FACT(s) (Environment):
OpenEdge 10.0x
All Supported Operating Systems
FIX:
When the OpenEdge SQL Engine optimizes a query, it will generate an "internal candidate list of indexes" that can be chosen to execute the query. If the INDEX hint provided by the client is one of the "internal candidate list of indexes", then the Optimizer will use it, otherwise, it will not use it.