Tri-State Db2 Technology Exchange
Db2 Users Group
Download PDF
Watch recording (logged in Tridex members only)
Session title: My Favourite Db2 Query Optimization Registry Variables
Session abstract: Optimal query access plans are essential for good data server performance, and it is the query optimizer’s job to choose the best one.
Continue reading “My Favourite Db2 Query Optimization Registry Variables”Registered Tridex members can also watch a recorded version of this presentation. Please make sure you’re logged in to access this protected content.
Continue reading “My Favourite Db2 Query Optimization Registry Variables”Watch recording (logged in Tridex members only)
Session title: Desperate Measure – How to Relieve the Db2 Optimizer of Its Duties
Session abstract: Optimal query access plans are essential for good data server performance, and it is the query optimizer’s job to choose the best one. However, occasionally no amount of statistics or tuning is enough to get the access plan you want. Or your application is effectively down, due to a poorly performing query, and there isn’t time to implement best practices.
Continue reading “Desperate Measure – How to Relieve the Db2 Optimizer of Its Duties”Registered Tridex members can also watch a recorded version of this presentation. Please make sure you’re logged in to access this protected content.
Continue reading “Desperate Measure – How to Relieve the Db2 Optimizer of Its Duties”Download PDF
Watch recording (logged in Tridex members only)
Session title: Db2 Query Optimization 101 session
Session abstract: Optimal query access plans are essential for good data server performance and it is the Db2 query optimizer’s job to choose the best access plan. The optimizer is a very sophisticated component of the data server, tasked with the challenging job of choosing good access plans for the variety of features and table organizations supported by Db2.
Registered Tridex members can also watch a recorded version of this presentation. Please make sure you’re logged in to access this protected content. Continue reading “Db2 Query Optimization 101 session”
Watch recording (logged in Tridex members only)
Session title: Db2 Turbo Statistics – How to Accelerate Your Query Performance
Session abstract: Catalog statistics are what fuel the Db2 optimizer, and its tank is always full because of automatic statistics collection. However there are some extra buttons on the dashboard that you can use to enable even better statistics to really boost your query performance.
Continue reading “Db2 Turbo Statistics – How to Accelerate Your Query Performance”
Registered Tridex members can also watch a recorded version of this presentation. Please make sure you’re logged in to access this protected content.
Continue reading “Db2 Turbo Statistics – How to Accelerate Your Query Performance – recording”Session title: What’s New with BLU in Db2 11.5 (and beyond!)
Session abstract: Db2 with BLU Acceleration provides industry leading performance for analytical applications running complex queries through its advanced column-organized table technology. Continue reading “What’s New with BLU in Db2 11.5 (and beyond!)”
Session title: Db2 Query Optimization 101
Session abstract: Optimal query access plans are essential for good data server performance and it is the Db2 query optimizer’s job to choose the best access plan. The optimizer is a very sophisticated component of the data server, tasked with the challenging job of choosing good access paths for the variety of features and table organizations supported by Db2.
Continue reading “Db2 Query Optimization 101”