Non clustered Vs Clustered Column store Index in Sql Server

Non clustered columnstore index:
1.Can index a subset of columns in the clustered index or heap. For example,
it can index the frequently used columns.
2.Requires extra storage to store a copy of the columns in the index.
3. It is not updateable by using the DML operations such as insert, update, and delete.
4.Can be combined with other indexes on the table.


a clustered columnstore index:

1.Is available in Enterprise, Developer, and Evaluation editions.
2.Is updateable.
3.Is the primary storage method for the entire table.
4.Has no key columns. All columns are included columns.
5.Is the only index on the table. It cannot be combined with any other indexes.

Please watch full video for more detail

[techBird-bm]

The way to teaching is bookish, like in college. We know the theory, this is that, that is this. But we need to know, custered and non clustered meaning. In memory how they organizing the data. and how CRUD operations effected by it.

[slaviivanov]

Last point for Clustered Columnstore Index is wrong - you can combine it with other indexes.