Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: explain plan: Which index columns are used ?
Jonathan Lewis wrote:
>
> 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.
Clock up another victory for DB2 :-)
--
There are 3,434,679 oracle websites around the world. Now there is one more... http://www.oracledba.co.uk Received on Wed Feb 09 2000 - 04:27:33 CST