Databases Reference
In-Depth Information
Figure 4-4:
Index Scan operator properties.
Note that, in Figure 4-4, the following predicate is, however, still evaluated on the Index
Scan operator.
abs([AdventureWorks].[Sales].[SalesOrderDetail].
[ProductID]) =CONVERT_IMPLICIT(int,[@1],0)
Listing 4-4.
In the case of a multi-column index, SQL Server can only use the index to seek on the
second column if there is an equality predicate on the first column. So SQL Server can use
