WMCPA Spring Conference 2018

The Db2 for i optimizer was specifically designed to maximize the value of the available indexes for both metadata and query implementation. Creating an index often provides a quick performance fix since you don't have to change any other settings and don't have to make any changes to the SQL statement or program. This session provides an overview of the indexing technology including features that are unique to Db2 for i, how the optimizer can take advantage of indexes to improve performance, and a simple roadmap for maximizing performance with minimal effort.