Is columnstore a good option for UPDATES with WHERE clauses?
Modifying a row will cause the old row to be flagged as &quot;deleted&quot; (but its still in the column store index) and the new row to be added to the deltastore (row-based storage which will be compressed when it reaches about 1 million rows). So, as you can imagine, many updates will to some extent degrade your columnstore index over time. You can of course do index maintenance, but a columnstore index on B might not be the best choice...