Database and Analytics

T15 SQL Server 2017 Execution Plan Basics

05/01/2018

3:00pm - 4:15pm

Level: Introductory

Thomas LeBlanc

Data Warehouse Architect

Data on the Geaux

This beginners' session will highlight the starting point for using execution plans from SQL Server to assist in query tuning. The session will briefly look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan with the properties window?

You will learn:

  • How to performance tune queries in SQL Server 2017 with execution plans
  • How to read SQL Server execution plans
  • How to use indexes to improve SQL Server 2017 queries