GilaMonster (11/26/2012)
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.
ah, ok 🙂 I thinkt the "in absence of"-part was the information I needed for understanding. So it seems that there is no "reliable" difference in the query plan. But with looking at the operators used in the quey text I should be able to "guess" what it is.
Thank's a lot for your help, I think I got it now 🙂