Stream: Nurburgring
Time: 16:45 - 17:45
This presentation will provide you with practical experience in using dynamic statement cache for SQL tuning purposes. This way you are able to obtain much more precision information about your SQL tuning efforts than just seeing a change in access path.
There is currently no attachment for Tuning SQL using EXPLAIN STMTCACHE
Claus E. Mikkelsen has 36 years of experience in various DB2 disciplines, mainly focused on writing and tuning SQL. The last eight years he has been working as a DBA. The focus areas are Db2 for z/OS and SQL tuning and Db2 backup/recovery.
Click here to give some Feedback so we can make it even better next year!