SQLServerCentral / SQL Server 2008 / SQL Server Newbies / HEAP entires in sys.Indexes / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 20:42:11 GMT20RE: HEAP entires in sys.Indexeshttp://www.sqlservercentral.com/Forums/Topic1408233-1292-1.aspxBecause there has to be an entry in there for tables without clustered indexes. Heaps get an index id of 0.Thu, 17 Jan 2013 02:40:13 GMTGilaMonsterHEAP entires in sys.Indexeshttp://www.sqlservercentral.com/Forums/Topic1408233-1292-1.aspxIndexes are either Clustered or Non-Clustered. Than why does the HEAP entries are shown in sys.indexes table?Thu, 17 Jan 2013 02:18:13 GMTShadab Shah