SQL Server Best Practices Article
Published: May 25, 2007Writers: Burzin Patel, Sanjay MishraContributors: Kohei Ueda, Michael ThomassyTechnical Reviewers: Stuart Ozer, Prem Mehra, Sunil Agarwal, Artem Oaks, Tengiz Kharatishvili, Mike Ruthruff, Hermann Daeubler, Tom Davidson, Eric Jacobsen, Lindsey Allen
In SQL Server 2005, any table can have either clustered indexes or be organized as a heap (without a clustered index.) This white paper summarizes the advantages and disadvantages, the difference in performance characteristics, and other behaviors of tables that are ordered as lists (clustered indexes) or heaps. The performance for six distinct scenarios where DML operations are performed on these tables are measured and detailed observations presented. This white paper provides best practice recommendations on the merits of the two types of table organization, along with examples of when you might want to use one or the other.
For more information, please refer to the Comparing Tables Organized with Clustered Indexes versus Heaps whitepaper.
Pingback from Twitted by paulrandal