07 A Better Clustered Columnstore Candidate

The small Users table isn’t a good fit for clustered columnstore because of its low size and its constant updates. We’ll pick a better table for columnstore indexes – the append-only Votes table – implement a columnstore index on it, then simulate daily load on it, and we’ll see why index maintenance is so hard…

The small Users table isn’t a good fit for clustered columnstore because of its low size and its constant updates. We’ll pick a better table for columnstore indexes – the append-only Votes table – implement a columnstore index on it, then simulate daily load on it, and we’ll see why index maintenance is so hard...
Menu
{"cart_token":"","hash":"","cart_data":""}