Clustered columnstore index

Question

Hello
I have a database with size 90 gb and it works online 7x24. Almost on all tables i have primary key. It means clustered index on each table. And now there is a new feature by Microsoft, clustered columnstore index. Everybody says: it is great feature. I want to use it, too. But how i understand, primary key and clustered columnstore index are not supported together. Please help me in this question: how my tables will be without primary keys?

Answer 1

Hello Ulvi,

You can have any combination of Indexes on a table, e.g. column store + Primary key (which is just a unique index) + further index, like we have on a table:

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 2

Thank you, for reply. But in this picture you typed non-clustered columnstore index. But i mean clustered columnstore index which is supported in SQL Server 2014. Any ideas?

Answer 3

See CREATE CLUSTERED COLUMNSTORE INDEX (Transact-SQL) => Limitations.

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 4

>Almost on all tables i have primary key. It means clustered index on each table.

PRIMARY KEY can have NONCLUSTERED unique index.

CLUSTERED index is the default for PRIMARY KEY but not a requirement.

---

Kalman Toth Database & OLAP Architect Free T-SQL Scripts
New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012