Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: forcing specific index on select

Re: forcing specific index on select

From: John P. Higgins <jh33378_at_deere.com>
Date: Sat, 06 Mar 1999 16:19:00 -0600
Message-ID: <36E1A9D4.50D39A9D@deere.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US