Databases Reference
In-Depth Information
Figure 4-2:
Index Seek operator properties.
The
SalesOrderDetail
table has a multi-column index with
ProductID
as the leading
column. The Index Seek operator properties, which you can see in Figure 4-2, include the
following Seek predicate on the
ProductID
column, which shows that SQL Server was
effectively able to use the index to seek on this column.
Seek Keys[1]: Prefix: [AdventureWorks].[Sales]. [SalesOrderDetail].ProductID =
Scalar Operator (CONVERT_IMPLICIT(int,[@1],0))
Listing 4-2.