columnstore index фича SQL Server 2012 и Dynamics?

[finn]

Интересную инфу нарыл:
http://dynamicsuniversity.com/blog/m...umnstore-index

Microsoft Dynamics GP with SQL Server 2012 and the Columnstore Index
...
The release of Microsoft Dynamics GP 2013 has introduced many new improvements. There are also some robust improvements for SQL 2012, which help support Microsoft Dynamics GP in the data warehouse.

New with SQL 2012, the xVelocity columnstore index does exactly as the name implies – stores data by columns instead traditional rows. How does this help you with the Microsoft Dynamics GP data warehouse? Columnstore indexes typically span all columns of a table, they do not require a primary key, and the column order has no effect on the index performance because SQL Server 2012’s black box processing automatically organizes and compresses the data in an extremely efficient manner.

How efficient is it? A columnstore index on a large table can increase the performance of OLTP transactions by as much as 100 times, and can span as many as 1024 columns.
...