Kbase P156463: How to specify an index hint for each element of a SQL Join?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/25/2009 |
|
Status: Unverified
GOAL:
How to specify an index hint for each element of a SQL Join?
GOAL:
How to specify an index hint for each element of a SQL Join?
FACT(s) (Environment):
OpenEdge 10.x
All Supported Operating Systems
FIX:
An index hint can be specified after each table is referenced in the query. For example:
SELECT TOP 100 customer.custnum, order.custnum, order.ordernum, orderline.linenum
FROM pub.customer WITH (INDEX(custnum))
LEFT JOIN pub.order WITH (INDEX(ordernum)) on order.custnum = customer.custnum
LEFT JOIN pub.orderline WITH (INDEX(linenum)) on order.ordernum = orderline.ordernum