All Forums UDA
marcmc 112 posts Joined 12/05
30 Sep 2008
Searching what table indices are used.

Is there a way of identifying what indices are actively/regulary used on a table?I have 13Gb of indices on a FACT table and when I remove them all my ETL is slightly faster but some of my troublesome reports(85 rpts) suffer significant degradation. I have a hunch what indices are being used but I would like to confirm this before starting a lenghty testing process.

10 Mar 2009

I think the only way is to capture the output of "explain plans" of all the queries and do a 'grep' on the secondary indexes before you analyze the text if the idex is used.

Ramakrishna Vedantam, Tata consultancy services, Hyderabad

You must sign in to leave a comment.