O'Reilly logo

Programming Microsoft® SQL Server® 2012 by Leonard Lobel and Andrew Brust

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

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 ...

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