Re: cardinality scripts

anon wrote:
>
> I'm looking for any scripts which can guide me toward discovering indexes
> within the database that can be dropped or converted to bitmapped indexes.
>
> Not all of our objects are analyzed so I can't use distinct keys from
> dba_ind_columns
>
> Any help is appreciated.
>
> thanks

When evaluating, you could just issue:

analyze index ... estimate statistics;
(then your tests)
analyze index ... delete statistics;

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."