Chapter17.SQL Optimization and Performance

Chapter 17. SQL Optimization and Performance

  • Access paths and optimization

  • Designing indexes and SQL for performance

Tuning DB2 queries is critical to performance. You need to understand how the DB2 optimizer works and how to create the best possible indexes for your queries. You also need to know how to determine whether DB2 is using that index and whether it is performing joins and other operations effectively by using the various tools available.

DB2 for z. OS Version 8 DBA Certification Guide
DB2 for z/OS Version 8 DBA Certification Guide
ISBN: 0131491202
EAN: 2147483647
Year: 2003
Pages: 175
Authors: Susan Lawson © 2008-2017.
If you may any questions please contact us: