Thursday, April 10, 2014

Non Clustered Index on HEAP ( A Table without a Clustered Index)

SQL Server allows us to create Non Clustered Index(es) on HEAP- A Table without Clustered Index.
A Heap doesn't have a Clustered Key, the SQL Server maintains a unique identifier for each row which is called as RID (Row Identifier) and maintains this RID along with Non Clustered Index