SQLBits 2012

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.

Ami Levin's previous sessions

Data loading at warp speeds

Do you struggle to reduce those frustrating long hours it takes to load data? Are your time windows for loading becoming too short for comfort? If so – you simply can’t afford to miss this session…

A heap of clusters

An in-depth dive into physical table structures

Physical Join Operators

See how the optimiser chooses the operators it does through real world examples.