This information is organized to give you an understanding of how DB2 UDB for AS/400 optimizes your queries, and how you can modify your applications and queries to get the best performance out of them.
Query optimization: concepts and processes
The following chapters describe DB2 UDB for AS/400 data access and the query optimizer:
Query optimization tools and tips
The following topics provide information about the tools and techniques you can use to monitor, troubleshoot, and effectively code your queries: