• It's a little buried in BOL for DBCC SHOWCONTIG, but Index ID 0 refers to a heap table, i.e., one without a clustered index.

    IndexIdID of the index. IndexId is 0 for a heap.

    A given table will always have one entry in sysindexes for either IndID = 0 or IndID = 1.  Of course, it can have other entries for every non-clustered index as well.

    Scott Thornburg