From the course: SQL Server Performance for Developers

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Nonclustered columnstore: Why?

Nonclustered columnstore: Why? - SQL Server Tutorial

From the course: SQL Server Performance for Developers

Start my 1-month free trial

Nonclustered columnstore: Why?

- [Instructor] Our next video is going to be about nonclustered columnstore indexes. You've heard about all the benefits of clustered columnstore indexes. The question is where would you want to use nonclustered columnstore indexes and the answers are getting pretty limited. Microsoft, especially with SQL Server 2016 and 2017, has kept increasing the benefits of clustered columnstore indexes. In the next video, we're going to walk through a very specific business scenario where you might want to use a nonclustered columnstore index, however, in most cases, especially in data warehouses or analytics workloads, you're going to want clustered columnstore just for the data compression. So let's talk a little bit more about nonclustered indexes. This was the original implementation in SQL Server 2012. Remember we couldn't update these in that version. And you cannot update nonclustered columnstore indexes in SQL Server 2014. That ability came into play in SQL Server 2016 which is going to…

Contents