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
Tilbakemeldinger
https://aka.ms/ContentUserFeedback.
Kommer snart: Gjennom 2024 faser vi ut GitHub Issues som tilbakemeldingsmekanisme for innhold, og erstatter det med et nytt system for tilbakemeldinger. Hvis du vil ha mer informasjon, kan du se:Send inn og vis tilbakemelding for