ColumnStoreIndex Property

Version: Available or changed with runtime version 8.0.

Sets the fields that are added to the ColumnStore index inside SQL Server.

Applies to

  • Table

Property Value

A comma-separated list of field names.

Syntax

ColumnStoreIndex = Field1,Field2;

Remarks

The property creates a nonclustered columnstore index on the table in SQL server. There can be only one nonclustered columnstore index on a table.

Using a nonclustered columnstore index can improve the performance for analytical queries on large tables.

For more information, see Columnstore indexes: Overview.

Get Started with AL
Developing Extensions
Table Keys