Microsoft SQL Server Adding clustered columnstore index on existing table


Example

CREATE CLUSTERED COLUMNSTORE INDEX enables you to organize a table in column format:

DROP TABLE IF EXISTS Product
GO
CREATE TABLE Product (
    Name nvarchar(50) NOT NULL,
    Color nvarchar(15),
    Size nvarchar(5) NULL,
    Price money NOT NULL,
    Quantity int
)
GO
CREATE CLUSTERED COLUMNSTORE INDEX cci ON Product