Demystifying clustered indexes

Uwe Ricken

If you ask an expert about using a clustered index you will ALWAYS hear: Yes, you need a clustered index for your table. Last but not least Microsoft Azure Databases requires clustered indexes. But clustered indexes are not always a good choice for your database solution because of several different reasons.

This session will start a debate about genius and madness of clustered indexes in your application. This session will run several demos which will show in a very clear way why a clustered index isn’t the best choice in several workload scenarios. “There’s no lunch for free”! Not using clustered indexes will have ONE heavy drawback – this drawback will be demonstrated, too.

The session goal is to make decisions easier for you to use a clustered index or not!