xVelocity in the RDBMS: Columnstore Indexes

We believe BI technology should not be viewed as separate from relational technology, but rather as something adjacent to it on the data spectrum. The addition of columnstore indexes to the SQL Server relational engine supports this view of data technology in a very concrete way. Many queries which before would have had reasonable elapsed timings only in SSAS can now be accommodated inside relational databases, too.

Columnstore indexes are indexes in every sense of the word. They reside in the relational database, are backed up and restored along with it, and are based on the columns you desire. The cost-based query optimizer in SQL Server will do a good job of using columnstore indexes when they are ...

Get Programming Microsoft® SQL Server® 2012 now with O’Reilly online learning.

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