Capture and Analyzie Estimation Plan

Introduction

The Capture and Analyze Execution Plan 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:

1. Use Actual and Estimated Execution Plan

Exercise 1- Use Actual and Estimated Execution Plans

In this exercise, you will learn the following in Microsoft SQL Server 2012 R2:

• Read and Interpret Actual Vs Estimated Execution Plan
• Demonstrate creation of Index using Execution Plan