how would i compare if two indexes are identical?

Erhan_toronto

I know owners are different but I only want to compare the columns not the owners... can we do that?

Unknown

Have you considered doing the comparison the old fashioned way and just look at the index definitions?

You could have compared them manually in a few minutes and you have already spent a day on it.

Lalit Kumar B

Erhan_toronto wrote:

What is this?

What do you expect it to be? You wanted a query to find out the duplicate indexes, right? So i gave you the query to do that. It will list out all the duplicate indexes.

Analyze on list and drop the duplicate indexes.

Erhan_toronto

Thanks for reply Lalit and sorry for the delayed response.. I got my answer allready.

APC

If you have an answer you should mark this thread as "answered", so people won't waste their time on this question.  

Cheers, APC