From the course: Microsoft SQL Server 2016 Essential Training

Unlock the full course today

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

Columnstore index

Columnstore index - SQL Server Tutorial

From the course: Microsoft SQL Server 2016 Essential Training

Start my 1-month free trial

Columnstore index

“

- [Instructor] In this section, we're going to talk about columnstore indexes. Creating a columnstore index is almost an identical process to creating a regular index off the IndexTest Table. I'll open that up, right-click on Indexes, go to New Index, Non-cluster Columnstore Index, and you see the interface is largely the same as it was for a typical index. So I'll cancel that, and instead for the demonstration, I'd like to look at one of the existing columnstore indexes on the WideWorldImporters database. I staged some code for you to run the query I like, so if you want to take that and copy all of it into a new query window, make sure it's running against the WideWorldImporters database. And we see at the top, similar to last time, we have a check point and we're cleaning the buffers, and then we're just going to run a select statement. The first time I run it, I'm going to use the option of ignore the columnstore index. So, we'll see what kind of performance we get when we ignore…

Contents