Utility to check if the indexes are being used in a table 
Author Message
 Utility to check if the indexes are being used in a table

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



Mon, 10 Apr 2000 03:00:00 GMT
 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



Mon, 10 Apr 2000 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. I am getting this message when i am tring to export or import anything using

2. error ORA-01855: AM/A.M. or PM/P.M. required

3. Busy Day = Slowdown from 12 AM - 5 AM

4. Use of @am, Am I dumb?

5. Patches (current CVS) for changes if index AM tables

6. Can I add coulmn in my existing table which i am using for replication

7. which table am I using ?

8. >I am currently interested in a sql script or utilities that will convert vms

9. check DateTime range btw 8:00 AM and 8:00 PM

10. Am I losing it - clustered indexes

11. Am I losing it - clustered indexes and uniqueness?


 
Powered by phpBB® Forum Software