weberharter (11/26/2012)
GilaMonster (11/26/2012)
Typically a scan is a full scan ...Hi Gila,
that's the point, it seems that it is NOT ALWAYS a full scan.
Well if you selectively quote me, yes what you quote will be incorrect.
What I said was
"Typically a scan is a full scan (in the absence of TOP or other operators that give row goals)"
Hence, if you see a scan and there is not something that could stop the scan part way through (Top, Min, Max, Row_Number, a couple of other similar operators) it is a full scan.
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