Re: Specifying an INDEX in a SELECT statement

Hi Chuck.

What you want is a 'hint' e.g.

select ....
from /*+ INDEX YOURINDEX */ YOURTABLE

hint is enclosed in comments /* . . . */ and + INDEX is the one you are after, not sure of exact syntax so you may have to try a few or look up hints in 'Oracle7 Server Tuning' if you have one...

Chuck Bayes wrote in message
<01bd2d03$0e237b00$6b421cac_at_CBAYES.wins.compaq.com>...
>I know it's a simple task (or at least it is in Sybase), but can anyone
>tell me how to force a query to use a specific index.
>
>Thanks in advance.
>
>Chuck
Received on Fri Jan 30 1998 - 00:00:00 CST