Re: explain plan: Which index columns are used ?

From: Daniel <delj_at_flash.net>
Date: Tue, 08 Feb 2000 15:26:19 GMT
Message-ID: <vAWn4.7209$wR.726832@news.flash.net>

I believe the entire index is used, not just one of the columns. That is the way indexes generally work.

Daniel
Austin, TX

"Gilles Cordier" <gcordier_at_lycosmail.com> wrote in message news:87p7k7$gm9$1_at_nnrp1.deja.com...
>
>
> Hi
>
> With explain plan, I know which indexes are used in a query.
>
> But in case of a concatenated index, is there a way to know which
> columns are used ?
>
>
> Thanks for your help,
>
> Gilles
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Feb 08 2000 - 09:26:19 CST