Runstats challenges for Optimal Query Performance

Download PDF

Session title: Runstats challenges for Optimal Query Performance

Session abstract: In DB2 development, we see many customers that are NOT following RUNSTATS collection “Best Practices”. But what are those best practices?  The largest contributor to poor query performance is insufficient or misleading RUNSTATS.Improving the availability of pertinent and accurate statistics is a huge opportunity for customers to improve DB2 performance and reduce instability of access paths.  What are the most common RUNSTATS collection mistakes and how to avoid them?  How do I identify the right default statistics?   How do I handle statistics on tables that fluctuate dramatically in data volume?   In this session, we’ll answer these questions and more as we discuss various runstats challenges and misconceptions.

Speaker biography: Terry Purcell is a Senior Technical Staff Member with the IBM Silicon Valley Lab, where he is lead designer for the DB2 for z/OS Optimizer. Terry has 25 years of experience with DB2 in SQL Performance and optimization as a customer, consultant and DB2 developer. Terry is an IBM Master Inventor with more than 25 U.S. patents for database search Technology.