白色IT商务企划：数据库工程师工作分析SQLQueryO.pptxVIP

David J. DeWittMicrosoft Jim Gray Systems LabMadison, Wisconsindewitt@? 2010 Microsoft Corporation.? All rights reserved.? This presentation is for informational purposes only.? Microsoft makes no warranties, express or implied in this presentation.SQL Query Optimization:Why Is It So Hard To Get Right? 2I am running out of things to talk aboutStill no motorcycle to ride across the stageMy wife decided to show up see what all the fuss was about!(She is probably the only one not tweeting back there)A Third Keynote?Generating all this PowerPoint takes me days and days (unlike my boss, I do not have people to do my slide decks) Day 3Day 2Day 1The “Impress Index”A Third Keynote?1Got to show off the PDW ApplianceCool!My boss’s boss (Ted Kummert) 2Got to tell you about SQL 11Awesome!My boss(Quentin Clark) 3You Are HereMe(David DeWitt) PossiblyIMPRESS YOU?How can I How About a Quiz to Start!4Who painted this picture?Mondrian?Picasso?Ingres?Actually it was the SQL Server query optimizer!!Plan space for TPC-H query 8 as the parameter values for Acct-Bal and ExtendedPrice are variedEach color represents a different query planYikes! P1P2P3P4SQL Server Who Is This Guy Again?DeWittSpent 32 years as a computer science professor at the University of WisconsinJoined Microsoft in March 2008Runs the Jim Gray Systems Lab in Madison, WILab is closely affiliated with the DB group at University of Wisconsin3 faculty and 8 graduate students working on projectsBuilt analytics and semijoin components of PDW V1. Currently working on a number of features for PDW V2M Today …I am going to talk about SQL query optimizationYou voted for this topic on the PASS web siteDon’t blame me if you didn’t vote and wanted to hear about map-reduce and no-sql database systems insteadMy hope is that you will leave understanding why all database systems sometimes produce really bad plansStarting with the fundamental principalsQuery OptimizationMap-Reduce Anonymous Quote “Query optimization is not rocket