Articles & Content

Archives

E07 - Battle-Proven SQL Tuning Techniques

Topic: DB2 for LUW

Subtopic: 2013



Learn how to capture, identify and tune suboptimal SQL using DB2 provided commands and utilities. Learn what to look for when looking for suboptimal SQL. Then, learn how to explain and analyze suboptimal SQL using db2exfmt, db2caem, Top 10 SQL script and MONREPORT stored procedure. Learn other techniques for identifying and fixing suboptimal SQL such as identification of unused or duplicate indexes; use of generated columns, date-time comparison corrections, use of optimization registry variables and settings, volatile tables, RUNSTATS selections, optimizer profiles and statistical views.



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.