Optimizing Queries

Practice Labs Module
Time
40 minutes
Difficulty
Intermediate

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.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

Overview

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.

Learning Partner
Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.