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
Monday, August 05, 2013
All Indexes on a Table
Labels:
DBA Tips for developers
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment