Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Concatenated Index
Doh see Sybrand's answer.
-- Niall Litchfield Oracle DBA Audit Commission UK "Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message news:3cfd34f4$0$8507$cc9e4d1f_at_news.dial.pipex.com...Received on Wed Jun 05 2002 - 00:43:13 CDT
> "Steve Johnson" <johnst_at_ncs.com> wrote in message
> news:ufq7veie7c0357_at_corp.supernews.com...
> > I can see the explain plan fine and have verified that it's using the
> index
> > as I want.
> >
> > My question was will the 2nd and 3rd columns of the index be used or
just
> > the leading edge.
>
> Well what does the explain plan actually say. Does it have a table access
or
> does it satisfy the query from an index scan of some type.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
>
>