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: Tue, 4 Jun 2002 22:45:24 +0100
Message-ID: <3cfd34f4$0$8507$cc9e4d1f@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 Tue Jun 04 2002 - 16:45:24 CDT

Original text of this message

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