Public preview: String and binary columns in clustered columnstore indexes

2017年1月4日

String and binary columns with unlimited size are supported in clustered columnstore indexes in Azure SQL Database (premium tiers). Clustered columnstore indexes can be created on tables that have large string or binary types, such as NVARCHAR(MAX), VARCHAR(MAX), and VARBINARY(MAX).

The following code shows an example of a table that contains the NVARCHAR(MAX) column with a clustered columnstore index created on top of the table:

CREATE TABLE Logs (
    DateLogged datetime2,
    Type varchar(20),
    Data NVARCHAR(MAX),
    INDEX cci CLUSTERED COLUMNSTORE
)

Clustered columnstore indexes provide high compression (up to 10x) of data in string and binary columns.

免費帳戶

免費取得 $200 的 Azure 點數與 12 個月的熱門服務

開始免費使用

Visual Studio

訂閱者每年最多可取得價值達 $1800 的 Azure 服務

立即啟用

啟動

加入 BizSpark 方案並取得免費 Azure 服務

深入了解