and the key value for the clustered index,
ContactTypeId. This is possible because the Lookup operator for non-clustered indexes to a clustered index is the key value of the clustered index.
- Chapter 2: Graphical Execution Plans for Basic Queries
- from SQL Server Execution Plans, 2nd Edition
- Publisher: Red Gate Books
- Released: October 2012
I don't fully understand this info - so - a non-clustered index always has lookup key value?
Share this highlighthttp://www.safaribooksonline.com/a/sql-server-execution/3714078/