Heap tables (tables without a clustered index) are generally not part of a good database design. Unless you never actually query your table, you should always put a clustered index on it. Heap table are generally slower on selects, updates and deletes. They are also generally slower on inserts if you decide to use a […]
Posts Tagged ‘Heap’
April 29, 2011 by Francois · 2 Comments
Filed under: Performance
Social Tagging: Clustered • Heap • Index • sql • sql server
Filed under: Performance
Social Tagging: Clustered • Heap • Index • sql • sql server
RSS