Articles & Content

Archives

Runstats Challenges for Optimal Query Performance

Topic: 2012 AU

Subtopic: DB2 for z/OS



Accurate and relevant statistics are the basis of reliable good query performance. However, the RUNSTATS options are often confusing and lead to incorrect usage by customers. How do I identify these cases and correct them? 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.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.