• C.K.Shaiju (4/1/2010)


    Hi Hugo,

    The 3rd and 6th options seems similar.

    Shaiju C.K.

    You are right! Thanks for pointing it out. The sixth option should have read "A clustered index exists ..." instead of "No clustered index exists ..."

    I have edited my post to prevent future confusion.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/