Databases Reference
In-Depth Information
There's more...
Keep in mind that, by creating a columnstore index, you are going to keep your table
read-only, and if partitioning is enabled on the table, data can still be loaded using the
partition switch mechanism. It will not allow any DML statements such as
INSERT
,
UPDATE
,
DELETE
, and others. Apart from these limitations, the tables and columns
cannot participate in a replication topology, and columns with large datatypes cannot
participate in a columnstore index as well as in computed columns.
To use DML statements, we have to disable columnstore indexes first,
because the columnstore index is mainly designed for data warehousing
purposes, where DML statements are not required.
Search WWH ::
Custom Search