Grant, I confused for a question when I'm reading <Dissecting SQL Server
Execution Plans>:
Following two T-SQL generate two different plans, but I don't know why:
--Clustered index scan
SELECT ContactID,LastName,EmailAddress FROM person.Contact WHERE...