Topic: 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
· 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
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.