Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server 2012 Property Editors › Column Store Index

Column Store Index

In SQL Server 2012, Columnstore Index groups and stores data for each column and joins all the columns to complete the index. Columnstore Index differs from traditional indexes which group and store data for each row and then join all the rows to complete the whole index. Columnstore Index improves the query execution time; it enables faster performance for common data warehousing queries such as filtering, aggregating, grouping, and star-join queries.

Note: For more information on Columnstore Index, refer to SQL Server 2012 documentation.