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 […]
To access this incredible, amazing content, you gotta get Recorded Class Season Pass or Fundamentals of Columnstore Indexes, or log in if you already shelled out the cash.