Close

Tuning SQL using EXPLAIN STMTCACHE

(IF)

Stream: Nurburgring
Time: 16:45 - 17:45


Presentation

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.

Attachments

IF Attachments

Speakers


  • Claus Ejner Mikkelsen at Nordea
  • 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.


    Email: c.mikkelsen@nordea.com

    Feedback

    Click here to give some Feedback so we can make it even better next year!