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 - SQL Server Tutorial
From the course: Microsoft SQL Server 2016 Essential Training
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…
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.