# 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
```al
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.
See https://learn.microsoft.com/sql/relational-databases/indexes/columnstore-indexes-overview.
## Related information
Get Started with AL<../devenv-get-started>
Developing Extensions<../devenv-dev-overview>
../devenv-table-keys

Copyright (c) Microsoft Corporation. CC BY 4.0, https://creativecommons.org/licenses/by/4.0/; code samples MIT. From https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-columnstoreindex-property, MicrosoftDocs/dynamics365smb-devitpro-pb at 828b6ee (2026-11-19). Changed: includes filled in, links to this site, and for agents shortened without dropping a fact. https://jonas-paprotka.de/docs/dev-itpro/developer/properties/devenv-columnstoreindex-property/
