Monday, August 05, 2013

All Indexes on a Table


Today i needed to compare indexes on few tables in two environments. I thought of using sql developer on two monitors and then comparing all indexes. Some table could have too many indexes and i do not rely on my eyes too much. So i thought about writing a query and i think this query can be be used to compare indexes on a table in two environments. If db link is available between two environments then we could use MINUS operator and see the differences

No comments:

Post a Comment