Create a columnstore index

Columnstore indexes can be created on dimension or fact tables:

  1. Right-click the dimension or fact table where the columnstore index will be added and access Detailed Properties > Indexes.
  2. Click Create a New Index button.
  3. Modify the Index Name of the columnstore index.
  4. Select Clustered or Non-Clustered Columnstore Index as the Index Type.
    Note: 

    Index Properties such as Unique, Ignore duplicate keys, Sort in tempdb, and Fill Factor, column ordering in ascending or descending order, and adding of include columns are disabled because these are restricted for Columnstore Indexes.

  5. Double-click the columns to be added to the non-clustered columnstore index.
    Note: 

    Clustered columnstore index do not need “Selected Index Columns” because it uses all the columns in the table. But some data types cannot be included in the columnstore index and should be omitted. See Microsoft documentation for more information.

  6. Click Apply or OK.
  7. Right-click the dimension or fact table and select Compile.
    Note: Clustered columnstore index is available in DWD 11.3.1 in SQL Server 2014.