This presentation will provide you with practical experience in using the dynamic statement cache for SQL tuning purposes. This way you are able to obtain much more precise information about your SQL tuning efforts than just seeing a change in access path.
2022 - Db2/DevOps
S204 - Tuning SQL using EXPLAIN STMTCACHE
- Details
- Parent Category: 2022 Stockholm
- Category: 2022 Db2/DevOps Track
- Hits: 1387
- DB2 Sessions: Room C first floor