CHAPTER 3Performance and Scalability

Microsoft SQL Server 2012 introduces a new index type called columnstore. The columnstore index feature was originally referred to as project Apollo during the development phases of SQL Server 2012 and during the distribution of the Community Technology Preview (CTP) releases of the product. This new index combined with the advanced query-processing enhancements offer blazing-fast performance optimizations for data-warehousing workloads and other similar queries. In many cases, data-warehouse query performance has improved by tens to hundreds of times.

This chapter aims to teach, enlighten, and even dispel flawed beliefs about the columnstore index so that database administrators can greatly increase query ...

Get Introducing Microsoft® SQL Server® 2012 now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.