Microsoft SQL Server CLUSTERED COLUMNSTORE Table with CLUSTERED COLUMNSTORE index
Example
If you want to have a table organized in column-store format instead of row store, add INDEX cci CLUSTERED COLUMNSTORE in definition of table:
DROP TABLE IF EXISTS Product
GO
CREATE TABLE Product (
ProductID int,
Name nvarchar(50) NOT NULL,
Color nvarchar(15),
Size nvarchar(5) NULL,
Price money NOT NULL,
Quantity int,
INDEX cci CLUSTERED COLUMNSTORE
)
COLUMSTORE tables are better for tables where you expect full scans and reports, while row store tables are better for tables where you will read or update smaller sets of rows.
