For the past 25 years Ami has been helping organizations derive value from data by teaching, consulting, and practicing data, databases, relational modeling and SQL.
A heap of clusters
An in-depth dive into physical table structures
A common myth claims that heaps are (mostly) evil and that every table should have a clustered index. In this session we will explore the fine details of both heaps and clusters and see if there is indeed any truth to this myth. We will look at (semi) real-life examples and understand when and why it is best to use heaps and clusters regarding multiple aspects of performance and maintenance.