As mentioned in the August 20th issue of the newsletter, the iSeries Navigator toolset was enhanced in V5R3 with a Show Indexes task. This new task, commonly referred to as Index Evaluator, provides more details on which indexes are being used by the DB2 query optimizer to improve the performance of your queries and SQL requests. Starting with V5R4, this same information can also be retrieved via a program using a DB2 catalog view. SYSPARTITIONINDEXSTAT in library QSYS2 is ...

REGISTER NOW TO ACCESS THIS ARTICLE

All registered users get access to premium content on iPro Developer for free.