Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Indexes

Re: Indexes

From: Reiner Neumann <reiner.neumann_at_messe.de>
Date: Fri, 11 Jun 1999 13:04:44 +0200
Message-ID: <7jqqgp$4gp$1@mail.messe.de>


No.

Terry Sullivan <terry_sullivan_at_sgsgroup.com> schrieb in im Newsbeitrag: 7jqj0q$g1h$1_at_lure.pipex.net...
> Hi there,
>
> I'm new to Oracle. If I have an index which uses multiple columns and the
> WHERE clause of my SELECT statement uses a column which is in the index
but
> NOT the first column in the index - will Oracle use this index to find the
> data?
>
> Thanks in advance.
>
> Terry Sullivan
>
>
Received on Fri Jun 11 1999 - 06:04:44 CDT

Original text of this message

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