Database Reference
In-Depth Information
13. The execution results and execution plan are as follows:
Table 'TransactionHistoryArchive'. Scan count 1, logical reads
622, physical reads 0, read-ahead reads 0, lob logical reads 0,
lob physical reads 0, lob read-ahead reads 0.
(5222 row(s) affected)
14. Create the required filtered index as follows:
USE [Adventureworks2008R2]
GO
CREATE NONCLUSTERED INDEX [IX_TransactionHistoryArchive_Upd_
ActualCost_ProductId]
ON [Production].[TransactionHistoryArchive]
([ModifiedDate],[ProductId]) where [ActualCost] IS NOT NULL
15. Once the preceding index is created, let us execute the update query from step 12.
The execution plan results are presented as follows:
Search WWH ::
Custom Search