Kbase P87325: What is the syntax for SQL index hints in OpenEdge 10?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/1/2010 |
|
Status: Unverified
GOAL:
What is the syntax for SQL index hints in OpenEdge 10?
FACT(s) (Environment):
OpenEdge 10.x
FIX:
Progress OpenEdge 10 supports index hints for SQL. For each table in the FROM clause of a SELECT query, the user can optionally specify an index. The SQL query optimizer will do its best to honor this hint.
Please find the syntax for SQL index hints below.
SYNTAX:
SELECT column_list
FROM table_list
WHERE
Where the "table_list" clause is as follows:
table_name [ [ AS ] table_alias ]
[ WITH (INDEX ( index_val ),...)]
EXAMPLE:
SELECT *
FROM pub.customer WITH (INDEX (countrypost))
ORDER BY country;
Where the "index_val" is the name of the index
If a candidate plan is generated with this index, then it will be used. If the optimizer is unable to generate a candidate plan with this index, then the hint will be ignored. The optimizer will still try to honor the other index hints for the other tables.