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: Concatenated Index

Re: Concatenated Index

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 5 Jun 2002 06:43:13 +0100
Message-ID: <3cfda4f4$0$8510$cc9e4d1f@news.dial.pipex.com>


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...

> "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
>
>
Received on Wed Jun 05 2002 - 00:43:13 CDT

Original text of this message

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