Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: forcing specific index on select
Just remember that this a hint. Just a hint. It usually works, but it is not a
force.
Jay Walters wrote:
> 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 Sat Mar 06 1999 - 16:19:00 CST