From the course: Developing Microsoft SQL Server 2016 Databases

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Create columnstore indexes

Create columnstore indexes - SQL Server Tutorial

From the course: Developing Microsoft SQL Server 2016 Databases

Start my 1-month free trial Buy for my team

Create columnstore indexes

“

- [Narrator] All of the tables that we've been working with have been examples of a rowstore structure, where individual records of a table are stored as rows. SQL server also supports an arrangement called a columnstore index, which separates out each column of a table when creating the index on disk. On the right dataset this can dramatically speed up queries that request only a couple of columns, especially from very wide tables, typically seen in a data warehouse scenario. In a rowstore table every column is stored in pages on disk, and when a page is full another is created to continue storing the records from the table. In this example we have a table that stores an ID, first name and last name, and a number of additional columns about these various authors. When a query is executed against the table all of the pages that make up the table are reassembled in memory. This means that every column from every row…

Contents