IBM® Optim™ Query Tuner for DB2® for Linux®, UNIX®, and Windows® provides
advanced query tuning capabilities for individual SQL statements that run
on DB2 for Linux, UNIX, and Windows data
servers.
When the license for IBM Optim Query Tuner for DB2 for Linux, UNIX, and Windows is
activated on your data server, the following activities are enabled:
- Viewing formatted SQL statements with statistical annotations
- Getting expert recommendations in the following areas:
- Designing indexes
- Writing SQL statements
- Influencing access path selection