What's new

Warehouse in Microsoft Fabric

SQL database in Microsoft

Fabric

Learn about which columnstore features available across SQL platforms and SQL Server

versions.

This table summarizes key features for columnstore indexes and the products in which they are

available.

For feature availability in Azure SQL Managed Instance with a SQL Server

update policy

, refer

to the column for the corresponding version of SQL Server.

Batch mode

execution for

multi-threaded

queries

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Batch mode

execution for

single-threaded

queries

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Archival

compression

option

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Snapshot

isolation and

read-committed

snapshot isolation

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Specify

columnstore

Yes

Yes

Yes

Yes

Yes

Yes

Yes

ﾉ

Expand table

1

2

AUTD

3