On any platform, good database performance depends on good
design. And good design includes a solid understanding of indexes and column statistics: how many to build, their structure and complexity, and their maintenance requirements. This is especially true for DB2 UDB for iSeries, which provides a robust set of choices for indexing and allows indexes and statistics to play a key role in several aspects of query optimization.

In this session, you will:
1. Be introduced to the new DB2 UDB for iSeries statistics manager and its automatic collection facilities.
2. Understand what indexes are important to the query optimizer for statistics.
3. Be able to determine what columns in a table are the best candidates for new indexes.
4. Understand what types of indexes (binary radix or encoded vector) they should be creating and how they will benefit the queries.
5. Understand how to proactively and reactively leverage database statistics to get the best SQL performance.
6. Understand what new tools are available to analyze your indexing strategy.