From 5.4 on, DB2 for IBM i has generated index advice, and System i Navigator has been enhanced every release to make it easier for you to see, understand, and act upon that advice. IBM i 6.1 and above also includes database statistical catalogs and SYSTOOLS, a repository for DB2 for i-supplied examples and tools. SYSTOOLS initially included two procedures that could be used to turn index advice into actual permanent indexes. With the most recent update from DB2 for i, the REMOVE_INDEXES ...

REGISTER NOW TO ACCESS THIS ARTICLE

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