Columnstore index on memory optimized table in SQL Server 2014

783 Views Asked by At

Can we create clustered/non-clustered columnstore index on a memory optimized table in SQL Server 2014?

3

There are 3 best solutions below

0
On

Columnstore Index is not supported with memory optimized tables.

0
On

Nope, you can't create a columnstore index on a memory optimized table, only nonclustered hash and nonclustered indexes are allowed, see here for more details:

Guidelines for Using Indexes on Memory-Optimized Tables

0
On

ColumnStore indexes are going to be supported on Top on In-memory/hekaton tables in SQL Server 2016.