Searching what table indices are used.

UDA
N/A

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.
1 REPLY

Re: Searching what table indices are used.

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.