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
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
