Loading…
Back To Schedule
Monday, October 4 • 4:45pm - 5:05pm
Knowledge is Power: How the Optimizer Uses Column Stats and Key Range Estimates to Make Queries Run Faster

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Database query performance depends on good access plans. The optimizer can build a good access plan when it has accurate information about the data your application is querying. Column statistics and key range estimates are both important sources of information that help the optimizer do its job. This session will peek "under the hood" of the optimizer to provide insight into how these database features work together to make for faster queries. The session will also cover options for configuring these features and best practices.

Learning Objectives:
1. Understand how column statistics and key range estimates help the optimizer._x000D_ 2. Apply best practices to configure these database features._x000D_

Speakers
avatar for Timothy Clark

Timothy Clark

Advisory Software Engineer, IBM


Monday October 4, 2021 4:45pm - 5:05pm CDT
Breakout 3 Online
  Database
  • Session Level All

Attendees (1)