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: Composite index question

Re: Composite index question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 13 Apr 2002 21:29:20 +0200
Message-ID: <2n1hbucb66f67lks5lk0fjiqcat6pkfdpk@4ax.com>


On Sat, 13 Apr 2002 18:51:36 GMT, "Tintin" <nospam_at_nospam.com> wrote:

>Learning Oracle 9i. Need some clarification on something.
>
>If I create a composite index on columns A, B and C and want to run a SELECT
>query that uses that index, do I have to specify the columns in the WHERE
>clause in the same order they are in the index?
>
>~ !T
>

No, definitely not.

--
Regards


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address
Received on Sat Apr 13 2002 - 14:29:20 CDT

Original text of this message

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