Modifying data within a highly compressed structure is expensive and requires additional processes to manage it successfully. Whereas insert operations can benefit from bulk loading to streamline data load processes, delete and update operations require using the delete bitmap and delta store to manage changes to existing data.
The Cost of Modifying Data
In Chapter 5, columnstore compression was discussed in extensive detail. An important takeaway is that some forms of ...
