Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Wednesday, April 18, 2018

Stairway to Columnstore Indexes Level 5: Adding New Data To Columnstore Indexes

SQLServerCentral.com Articles
Stairway to Columnstore Indexes Level 5: Adding New Data To Columnstore Indexes

Earlier levels have shown how Columnstore Indexes work effectively with static data. In most tables however, data is hardly ever static. We are constantly inserting new rows, and updating or deleting existing rows. If you think about what this means for a columnstore index, you will realize that this comes with some unique challenges.

No comments: