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.
See Also
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for