• Bob Cullen-434885 (10/19/2010)


    I chose #1 because all the others appeared to be referencing indexes, and there was nothing in the question that stated the table had an index.

    Maybe I'm missing something here...?

    If the table has a clustered index, information is stored in the system views as the index with index id 1.

    If the table has no clustered index, information is stored in the system views as the index with index id 0. Not a real index, but apprently Microsoft decided to take a practical approach and not use specific different system views for heaps (tables without clustered index).


    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/