From the course: SQL Server Performance for Developers
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Where you might not want a clustered index - SQL Server Tutorial
From the course: SQL Server Performance for Developers
Where you might not want a clustered index
- [Narrator] You've learned about why, most of the time, you should probably always use a clustered index on your SQL Server tables. Now, let's talk about the few scenarios where you might not want a clustered index. These do exist and different people use SQL Server in many different ways, so it is important, as you gain mastery of the development process, to have an understanding of what scenarios are good for what design patterns. We talk about design patterns for where we don't necessarily want a clustered index, we're going to be mainly looking at things like E.T.L. staging tables. If we think about a data warehouse, where we're unloading a lot of data each day, or maybe even a few times a day, from disparate, we'll say for example, point of sale systems, say we want to have a record of all of our sales at all of our store locations. You know, we're loading that into a data warehouse a few times a day, and that could be hundreds of thousands of records at a time, depending on the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.