Rich wrote:
> It seems I've searched for years on this one, on and off, but haven't
> ever found an acceptable answer. I have a table x with a single
> composite index created on columns a, b, c (in that order). I'm
> interested to know HOW MUCH of the composite index a particular query
> is using - is it using column a in the index, columns a and b, or all
> three parts of the composition?
>
> rjh
Explain Plan using the DBMS_XPLAN built-in package plus a little bit
of deductive reasoning.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Jun 17 2005 - 17:03:10 CDT
