Re: forcing specific index on select

From: Jay Walters <jwalters_at_computer.org>
Date: Fri, 05 Mar 1999 22:33:59 -0500
Message-ID: <36E0A227.D84050EB@computer.org>

What you want is called an optimizer hint. I think they're covered in the performance guide, but the hint for an index is INDEX(tablename indexname), and it will look something like

SELECT /*+ INDEX(foo foo_idx) */

a, b
FROM foo
WHERE .... cosmini_at_my-dejanews.com wrote:
>
> hi all,
>
> I was wondering if it is possible (and if it is so, what is the syntax) on
> forcing a specific index during a select.
>
> thanks,
>
> Cosmin
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Mar 05 1999 - 21:33:59 CST