Query Optimization by David DeWitt at SQLPASS: Awesome!

Wow!  Amazing to listen to such an expert in the database technology field.  He presented way way more than I could possibly process this morning.  His keynote should be posted here later today.  David works at Microsoft Jim Gray Systems Lab in Wisconsin.  Here is the slide deck from his presentation:

PASS Summit 2010 Keynote David DeWitthttp://static.slidesharecdn.com/swf/ssplayer2.swf?doc=pass2010finalfull-101111074859-phpapp02&stripped_title=pass-summit-2010-keynote-david-dewitt&userName=GraySystemsLab

View more presentations from GraySystemsLab.

“Query Optimization is not rocket science.  When you flunk out of  query optimization, we make you go build rockets.”  After getting a little visibility today into this field, I believe it.  Wow!

Takeaway for me was the importance to query optimization of updating statistics.  As I deal mostly with data/reporting/BI, I either forgot that, or never grasped the connection.  But David’s presentation today really opened my eyes to the need to make sure statistics are being updated.

Advertisement