2 ms·
Right, but I would argue that it is a form of an index. An index is simply an internal derived data structure that has to be kept in sync with the source datase
by wenc 8y ago
Right, but I would argue that it is a form of an index. An index is simply an internal derived data structure that has to be kept in sync with the source dataset.
All indices are derived views of the original dataset that are optimized with certain characteristics.
- manigandham 8y agoThere 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.