Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Composite index question
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 addressReceived on Sat Apr 13 2002 - 14:29:20 CDT