Understanding SQL Execution Plans with Eugene Meidinger
Learn about SQL execution plans from Eugene Meidinger of All Lines Technology. Discover what execution plans are, how to view them, what they look like, and how to interpret them. Join the discussion on this essential aspect of SQL query optimization.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Basic Execution Plans Eugene Meidinger emeidinger@all-lines-tech.com @sqlgene www.sqlgene.com
Who is All Lines Technology? All Lines Technology is a local woman owned solutions provider with corporate headquarters in Warrendale, PA, with offices in Cleveland, Columbus and Morgantown. Our parent company, Fire Fighter Sales & Service Co. has been in business since 1946, supplying fire suppression and life safety products and services to over 15,000 customers in the tri-state area. Customer service has been the cornerstone of our business for over 60 years. Strong company foundation and financial stability achieving year of year profitable revenue growth.
Who is LANtek? Staffing Named largest, local Staffing Firm in Western PA since 2011 Hardware Break / Fix Application Development SharePoint Services NOC / Help Desk Services Network/LAN/WAN Design &Delivery Datacenter Design &Architecture PC Deployment VDI and BYOD Solutions Cloud Services, including LANtek hosted &MS Office 365 & Azure
Who am I? Accidental DBA Graduated Penn State 2010 for IST First Job was in BI department at Bayer Head of small BI department at FF/ALT/Lantek Certified in Querying SQL Server 2012 Started speaking a year ago Don t go to the SQL Saturday after event! You ll get drafted Not an expert, just know enough to speak
What are we going to talk about? What is an execution Plan How to view an execution plan What does a plan look like How to read one Demo Resources Q/A
What is an execution plan? Instructions for how to process a query Can think of it as a recipe Created by query optimizer at run time Execution plans are cached after the first run Many different ways to process the same query For trivial queries, a simple plan is used Can be forced with hints Don t try to outsmart the database engine
How to view the execution plan? Go to Query Click Include Actual Execution Plan Or, Press Ctrl + M Or click the Execution Plan Icon on the tool bar
How to read an execution plan Read from right to left and top to bottom Icons represent operators Operators have cost below them in % Arrows represent data flow Bigger arrows represent more data Hover over icons and arrows for more detail
Resources Adventure Works Database Execution Plan Basics by Grant Fritchey SQL Server Execution Plans, Second Edition by Grant Fritchey Watch Brent Ozar Tune Queries by Brent Ozar
Questions? Thank you!
