Re: Tuning

Robert & Amelia Webb wrote:
>
> I am doing some access path tuning on Oracle 7.3.4 / Oracle 8.0. When I use
> EXPLAIN PLAN I can easily tell which tables are being accessed and if the
> access is using an index. Is there a way to tell how many keys of the index
> are being used?
>
> For example if I have an index on 2 columns A and B ( in that order) where A
> has the same value for all rows and B is unique across all rows it would be
> extremely helpful to determine if the indexes was being accessed on a match
> of just column A or on both columns A and B.
>
> Thanks,
>
> Robert

Unfortunately no...DB2 has had this for a long time, but Oracle does not (as of 8.1.5)...Typically this means looking that SQL and deducing the number of columns...

HTH

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

"Beta, n: Latin for 'still does not work'"