David Walker-278941 (11/23/2010)
"This does not mean that the index 'NonClust_Contact_Name' was not useful. It's still much better than the Clustered scan."*WHAT* is still much better than the clustered scan? I'm confused by that last sentence.
I'm confused about this comment as well....
Since we aren't shown a table definition with details about the clustered index, the only thing I could come up with is a scenario where the clustered index is "wider" (contains more data) than the non-clustered index. Thus the non-clustered index would be smaller and therefore preferred from an efficiency perspective. Maybe. If this was a heap would the RID be smaller, and the optimizer prefer a table scan? I don't know...