From the course: Designing Database Solutions for SQL Server 2016

Unlock the full course today

Join today to access over 23,300 courses taught by industry experts.

Sort data with columnstore indexes

Sort data with columnstore indexes - SQL Server Tutorial

From the course: Designing Database Solutions for SQL Server 2016

Start my 1-month free trial Buy for my team

Sort data with columnstore indexes

“

- [Voiceover] One of the more recent features added to SQL Server, is the ability to create table indexes that organize records in a different way. Typically, indexes and tables follow row store structure, where individual records in a table are stored as complete rows. SQL Server also supports an arrangement called columns store indexing, which separates out each column of a table when creating the index on disk. On the right data set, this can dramatically speed up queries that request only a couple of columns, especially from very wide data tables, typically seen in a data warehouse scenario. In a row store table, every column is stored in pages on disk and when a page is full, another is created to continue storing records from the table. In this example, we have a table that stores an ID, first name, 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…

Contents