Re: Indices

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/04/26
Message-ID: <956773897.25319.0.pluto.d4ee154e@news.demon.nl>#1/1

As long as this involves the _leading_ columns the index will be used.

Hth,

Sybrand Bakker, Oracle DBA

craibuc <craibucNOcrSPAM_at_hotmail.com.invalid> schreef in berichtnieuws 055c9c20.bcb6cb5e_at_usw-ex0105-035.remarq.com...
> If I have a multi-column index on a table, and I only use a
> subset of the index's columns in a query, will the index be
> used? What are the rules?
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Wed Apr 26 2000 - 00:00:00 CDT