Optimizing Queries
The "Optimizing Queries" module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises: Reading and Interpreting Query Plans, Reading IO statistics.
Introduction
The Optimizing Queries module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:
- Reading and Interpreting Query Plans
- Reading IO statistics
Lab time: It will take approximately 30 minutes to complete this lab.
Exercise 1 - Reading and interpreting Query Plans
In this exercise, you will learn the following:
- Reading and interpreting Query Plans
- Creating Plan Guides
- Working with Dynamic Management Views
- Reading IO statistics
- Evaluating dynamic queries vs. Parameterized queries
- Using HASH, Merge and LOOP Joins
Exercise 2 - Reading IO statistics
When working with SQL Server, you can view information related to the amount of disk activity generated by Transact-SQL statements by using the Statistics IO option. When the STATISTICS IO option is set to ON, SQL Server displays the statistical information for all the subsequent Transact SQL statements. At any point if you want to stop viewing the statistics, you set this option to OFF.
See the full benefits of our immersive learning experience with interactive courses and guided career paths.