OnDemand SQL Performance Analysis Simplified on DB2 for i5/OS in V5R4

218 OnDemand SQL Performance Analysis Simplified on DB2 for i5/OS in V5R4

You can see the number of different indexes that are advised and how many times they are

advised. To see this information, run the query shown in Example 6-34.

Example 6-34 Listing of distinct index advised

SELECT distinct qvqtbl "Table", qqidxd "Key Fields",

count(*) "Times adviced"

FROM MYDBMON

WHERE qqrid IN (3000, 3001, 3002) and qqidxa='Y'

GROUP BY qvqtbl, qqidxd

ORDER BY qvqtbl, qqidxd;

Figure 6-32 shows the results of the query in Example 6-34.

Figure 6-32 Different index advised

This is a good example where creation of the index on table QA1A1RMT with the key field,

R1MSYS ...