SQL optimization is critical to improving application performance. When SQL queries and workloads in applications are not tuned for optimal performance, application degradation can put revenue at risk, lower customer satisfaction, and increase infrastructure costs.
For a list of some of the scenarios in which query-workload tuning can be helpful and procedures that you can follow for each scenario, see Scenarios for tuning query workloads.
To learn how to do tasks that are related to tuning query workloads that run on DB2 for Linux, UNIX, and Windows, see Tuning query workloads that run on DB2 for Linux, UNIX, and Windows.
To learn how to do tasks that are related to tuning query workloads that run on DB2 for z/OS, see Tuning query workloads that run on DB2 for z/OS.
To learn how to do tasks that are related to tuning single SQL statements that run on DB2 for Linux, UNIX, and Windows or DB2 for z/OS, see Tuning single SQL statements.
For a description of the components of IBM InfoSphere Optim Query Workload Tuner, Version 4.1.1, see the section “Product components” in Installing IBM InfoSphere Optim Query Workload Tuner, Version 4.1.1”.