Database Reference
In-Depth Information
6.
It is evident that the query is using a Clustered Index Scan on the
Production.
TransactionHistoryArchive
table with the scan count and logical reads from
the disk.
7.
By selecting the actual execution plan during the query execution gives us information
on the missing index too, where it is suggesting to create a
NONCLUSTERED
index
on
Quantity
,
ModifiedData
by including
TransactionID
,
ProductID
,
ReferenceOrderID
,
TransactionDate
,
TransactionType
, and
ActualCost
columns.
8.
So, to create the missing index as per the preceding information, on the query results
window at the Execution plan tab, right-click and choose Missing Index Details. It
will present a new query window with the following TSQL:
/*
Missing Index Details from FilteredINdexes.sql - DBIA-SSQA\
SQL2K8R2u.Adventureworks2008R2 (DBIA-SSQA\ssqa.net (52))
The Query Processor estimates that implementing the following
index could improve the query cost by 75.7036%.
*/
/*
USE [Adventureworks2008R2]
GO
CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname,>]
Search WWH ::
Custom Search