SQLServerCentral.com / SQL Server 2008 - General / SQL Server 2008 / HEAP index ???? / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 31 Mar 2015 16:44:30 GMT20RE: HEAP index ????http://www.sqlservercentral.com/Forums/Topic1433932-391-1.aspxthank yougot itThu, 21 Mar 2013 12:07:03 GMTSD1999RE: HEAP index ????http://www.sqlservercentral.com/Forums/Topic1433932-391-1.aspxIn the sys.indexes table an index_id of 0 indicates that the table is a heap, no clustered index. An index_id of 1 indicates that there is a clustered index. These two values are mutually exclusive. A table is either a heap or has a clustered index (i.e. the table).Thu, 21 Mar 2013 11:31:09 GMTLynn PettisHEAP index ????http://www.sqlservercentral.com/Forums/Topic1433932-391-1.aspxCAn you please help me figure this one out??In MS, I am looking at the table and see no indexes there...However, running this select and get the following result:SELECT * FROM SYS.INDEXES I WHERE I.object_id = object_id('TABLENAME')object_id927342368nameNULLindex_id0type0type_descHEAPis_unique0data_space_id1ignore_dup_key0is_primary_key0is_unique_constraint0Thu, 21 Mar 2013 11:25:19 GMTSD1999