Re: Query optimisation

What vesion of Oracle? Are you set up for cost or rule? Did you analyze the table to get stats?

Roger Snowden
rsnowden_at_labinterlink.com

terryg8 <trg_at_ibm.net> wrote in article <34784E4C.1C1C_at_ibm.net>...
> Geoff Dewhurst wrote:
> >
> > Hi,
> >
> > Even when I use a hint, it still does not want to use that index! I
 thought
> > that a hint would force it to use the index, but that does not seem to
 be
> > the case. Any thoughts?
> >
> > Geoff
> >
> > Keith Boulton <boulke_at_globalnet.co.uk> wrote in article
> > <3472cca1.506968_at_read.news.global.net.uk>...
> > > On 18 Nov 1997 23:24:40 GMT, "Geoff Dewhurst"
 <Geoff_at_Bass-Soft.com.au>
> > > wrote:
> > > .....
> > > Even using an index the second query would be slower than the first
> > > because of the need to perform a table access. You could use the
 index
> > > hint to see the performance with an index e.g.
> > >
> > > SELECT /*+ INDEX( CLR CLRIDX ) */ CODE FROM CLR WHERE CLRIDX =
  Received on Mon Nov 24 1997 - 00:00:00 CST