Mastering Index Design to Improve Query Performance
Project and Program: Information Management
, SHARE Pittsburgh 2019
DBAs may find themselves in the middle of performance problems that must be fixed before business systems are negatively affected. Db2 indexes play a major role when processing SELECT statements, however could burden DB2 subsystem resources or interfere with the function of other applications.
Come to this session and learn how to lower your risk of poor Db2 system performance. The session will cover index structure (CLUSTERED and NOT CLUSTERED), how to look at an EXPLAIN and understand what values are the major influencers in improving performance, how to design the best index for a single query, what are filter factors and how they help the optimizer, how predicates are processed and how to trick the optimizer without using OPTHINT.-Rodolfo Custodio-Broadcom
Back to Proceedings File Library