White Papers

53 BP1062 | Best Practices for Decision Support Systems with Microsoft SQL Server 2012 using Dell EqualLogic PS Series

Storage Arrays

B Columnstore index

T-SQL query to create and align the columnstore Index along the table partition scheme is as follows.

USE [300_TPCH_DB]

SET ANSI_PADDING ON

CREATE NONCLUSTERED COLUMNSTORE INDEX [NonClusteredColumnStoreIndex-20130620-

123327] ON [dbo].[H_Lineitem]

(

[l_orderkey],

[l_partkey],

[l_suppkey],

[l_linenumber],

[l_quantity],

[l_extendedprice],

[l_discount],

[l_tax],

[l_returnflag],

[l_linestatus],

[l_shipdate],

[l_commitdate],

[l_receiptdate],

[l_shipinstruct],

[l_shipmode],

[l_comment]

) WITH (DROP_EXISTING = OFF) ON [LineItem_8_PS]([l_shipdate]);