Utility to check if the indexes are being used in a table
CYRANO has a product for performance and tuning that is supposed to do
just that.
We looked into it at one time, but managment decided not to get it.
Good Luck
Dean Sheaffer
Quote:
> Hi,
> Does anyone know of a way to find out if indexes created in tables are
> being used or not ? We have a situation where there are many indexes
> being built in our tables and more indexes created as required, But I
> would like to drop any unwanted index present on the tables.
> The only way I thought we could check is go through the showplan on
> every stored procedures and grep all the index used on tables. I did
> write a perl script to do that but it becomes cumbersome to check all
> the triggers and stored procedures. Does any one have a better
> solution
> or any tool available to do this ?
> TIA,
> Malathy Sundaram
