| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: cardinality scripts
"anon" <anon_at_hotmail.com> wrote in message news:<Y40I7.129707$IR4.41030347_at_news1.denver1.co.home.com>...
> 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
A little piece of dynamic sql that performs an 'analyze index Z validate structure' and inserts the row from index_stats into a collection table could help here. The collection table should also have the index_name. A few smart queries should help identify the lesser cardinal indexes.
Ronald.
 |
 |