Archives

D15 P1 - Query Performance and Optimizer Specific Type of Issues

Topic: DB2 for LUW

Subtopic: 2015

This topic discuss various ways on how to influence/improve query performance and different technique’s to addredd optimizer specific type of issues. It also includes a
high-level overview of the Optimizer functionality and codepath.
· DB2 Opimizer Introduction and Codepath
· DB2EXFMT Tool
· DB2 Configurations and Environment Registry Settings
· Query Optimization Level (OPTLEVEL)
· RUNSTATS , Catalog Statistics, and Cardinality Estimates
· Statistical View
· Optimizer Specific Type of Issues

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