O'Reilly logo

Pro SQL Server Internals, Second Edition by Dmitri Korotkevitch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© Dmitri Korotkevitch 2016

Dmitri Korotkevitch, Pro SQL Server Internals, 10.1007/978-1-4842-1964-5_34

34. Columnstore Indexes

Dmitri Korotkevitch

(1)Tampa, Florida, USA

This chapter provides an overview of the different columnstore index types available in various versions of SQL Server. It discusses their internal structure as well as best practices for data loading and maintenance.

Columnstore Index Types

As mentioned in the previous chapter, there are several different types of columnstore indexes supported in SQL Server. Unfortunately, the terminology is quickly become confusing and version-specific. For example, nonclustered columnstore indexes in SQL Server 2012/2014 and in SQL Server 2016 are, in a nutshell, very different objects; however, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required