weberharter (11/26/2012)
The point is, many of our foreign keys reference to columns that are the clustered index so many joins result in clustered index lookups or scans. And that's where I want to know the difference.
Those will be full scans. Lookups are single row clustered index seeks.
As I said earlier, there's nothing in the operator itself that will tell you whether it's a full or a partial, but in the absence of TOP or other operators that give row goals, it is a full scan of the entire index.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability