QUESTION POSED ON: 18 March 2004
I manage an iSeries that serves as the enterprise server for a large ERP package. Over the past year, I have created many indexes using the "Advisor" application within Operations Navigator/SQL Scripts. Accordingly, our "Read only" DSS reports run much better than they use to. While our OLTP performance is also currently acceptable, I want to begin an audit on all of our current indexes.
Unfortunately, the ERP installation creates a myriad of composite indexes, with redundant columns -- all in various orders. Trying to audit this will be cumbersome, to say the least.
I am trying to find a method that can help me determine what indexes are being used and what indexes are not. With 3500 tables and many indexes, trying to intercept SQL manually, and log what indexes are being used, isn't feasible. Can you offer any suggestions?
|
