Analyzing Query Performance - SQL Server Query Performance Tuning - page 96

Figure 7-5. Data retrieval mechanism for the SalesOrderHeader table
In the operator properties for the SalesOrderHeader table, the Object property specifies the index used,
PK_SalesOrderHeader_SalesOrderID . It uses the following naming convention: [Database]. [Owner].[Table Name].
[Index Name] . The Seek Predicates property specifies the column, or columns, used to find keys in the index.
The SalesOrderHeader table is joined with the SalesOrderDetail table on the SalesOrderld column. The SEEK
works on the fact that the join criteria, SalesOrderld , is the leading edge of the clustered index and primary key,
PK_SalesOrderHeader .
Sometimes you may have a different data retrieval mechanism. Instead of the Seek Predicates property you saw
in Figure 7-5 , Figure 7-6 shows a simple predicate, indicating a totally different mechanism for retrieving the data.