Re: Auditing on using indexes

The index tuning part of the expert package in Enterprise Manager essentially does the same thing. It samples your sql area and stores all the sql statements it finds and then looks at all your indexes and sees which ones are not used. It might actually work if you feel you can get a big enough sample to insure you are capturing all your sql. If you don't sample for long enough you might miss sql that is only run weekly or monthly. Received on Wed Aug 08 2001 - 15:55:52 CDT