Re: Indices

craibuc wrote:
>
> 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!

If you specify the leading values then the index can be used..

If you only want index columns returned, then an index full scan can be used.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse