Re: explain plan: Which index columns are used ?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 8 Feb 2000 19:09:02 -0000
Message-ID: <950038307.5632.0.nnrp-09.9e984b29@news.demon.co.uk>

Unfortunately not.
There is a column in the plan_table called SEARCH_COLUMNS which sounds so
promising, but it has never been implemented.

However, given the execution path, you should be able to infer from the SQL which columns will have been 'usefully' used and which were used as a result of an index scan.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Gilles Cordier wrote in message <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 - 13:09:02 CST