Announcing a Very Special #SQLFamily Webcast with Dr. David DeWitt

On Thursday, June 28th, at noon Eastern (see in your local time zone), join us for a very special presentation:

SQL Query Optimization. Why is it so hard to get right?

Dr. David DeWitt

The first paper on cost-based query optimization was published in 1979 by Patricia Selinger from IBM Research. This paper laid the basic framework for optimizing relational queries that is still in place today. While there have been many technical enhancements since 1979, query optimizers still fail to pick the best plan when faced with a complex SQL query.

In this talk I will describe the basic mechanisms used by modern query optimizers including plan enumeration, the use of histograms to estimate selective factors, and plan costing. I will also talk about a new approach to query optimization that I believe will revolutionize the optimization of queries in the cloud.

About the presenterDr. David DeWitt has positively wowed audiences at the PASS Summit over the years, consistently delivering amazing technical keynote presentations. You can read his bio at LinkedIn, or check out his Wikipedia page, or his past work at the University of Wisconsin. He could talk about pretty much anything, and I’d listen.

Here are the slides, but note that they use animations extensively – for the best effect, download the PowerPoint directly and step through it in presenter mode to see the animations.

Previous Post
Demoing Latch Waits with Stupid Tricks
Next Post
[Video] Office Hours 2018/6/6 (With Transcriptions)

2 Comments. Leave new

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.