2 ms·
There might be confusion here. The feature is called columnstore indexes but it has 2 modes: clustered or nonclustered. In clustered mode, the table itself is c
by manigandham 8y ago
There might be confusion here. The feature is called columnstore indexes but it has 2 modes: clustered or nonclustered. In clustered mode, the table itself is converted to column-oriented data format and is not a derived dataset. Adding a nonclustered columnstore index though will create a separate copy of the table to be maintained.
A column-oriented table can also have regular b-tree indexes as well. Perhaps it's unfortunate that they used indexes as the main interface for managing these table types instead of explicit language.
- wenc 8y agoThanks for the clarification -- I wasn't aware that clustered and non-clustered modes were stored differently on disk. I stand corrected.