Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Indexes
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
![]() |
![]() |