The best approach would be to make sure you have run EXPLAIN on all of your production plans and packages. Then examine the PLAN_TABLE output for those indexes. For example:
SELECT *
FROM my.PLAN_TABLE
WHERE ACCESSNAME IN (put your list of indexes here);
Of course, this will not show the dynamic SQL that uses any of these indexes. There are tools on the market that can help you to gather SQL usage statistics and access path information for both static and dynamic SQL statements.
Consider acquiring one of these tools if you use a lot of dynamic SQL. One such offering is BMC Software's SQL Performance for DB2 solution. Click here for more information.
Editor's note: Craig Mullins is director of technology planning at BMC Software Inc.
Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our discussion forums.
|
