Articles & Content


Query Performance and Optimizer Specific Type of Issues

Topic: 2014 AU

Subtopic: DB2 for LUW

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
· DB2 Configurations and Environment Registry Settings
· Query Optimization Level (OPTLEVEL)
· RUNSTATS , Catalog Statistics, and Cardinality Estimates
· Statistical View
· Optimizer Specific Type of Issues

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.