4 Salient Differences between Heap Tables and Clustered Tables in SQL Server
The following article explains the key differences between Heap tables and Clustered tables. While working with tables in SQL Server, users often face the dilemma to use clustered tables or heap tables. Tables which don’t have clustered indexes are called Heap Tables and those having clustered indexes are called Clustered Tables. A Clustered index basically reorders the way in which records are stored physically in a table. The data pages are contained in the leaf nodes of a clustered...
Read more »