Name: D11 | Optimization 101: What Makes Db2 Choose Certain Access Paths
Start: 2024-10-30T11:30:00+0100
End: 2024-10-30T12:30:00+0100

Wednesday October 30, 2024 11:30 - 12:30 CET

1 | Breakout 8

What makes Db2 chose certain access paths? Why that index? Why that join method?
There are many things that the optimizer code looks at when determining an access path to retrieve the requested data for a query. This presentation will focus on the main areas that drive the optimizer choices, what control we might have over some of them, and some of the defaults that take place. This is a 'must see' for those that want to get stronger in performance and tuning and undertand many of the basics.

Speakers

Tony Andrews

Developer, Trainer, Performance and Tuning Consultant, P&T Solutions, Inc.

Tony Andrews has more than 25 years’ experience in the development of relational database applications. Most of this time, he has provided development and consulting services to Fortune 500 companies and government agencies. Tony has written literally thousands of queries and programs... Read More →

Wednesday October 30, 2024 11:30 - 12:30 CET
1 | Breakout 8

Technical Session

Subject AppDev
Area Back to Basics, Performance and Monitoring, Working with SQL

IDUG EMEA 2024

Tony Andrews

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!