03 How Columnstore Data Is Selected
Now that you understand how columnstore data is stored in row groups, column segments, and delta stores – that it’s kinda partitioning on steroids – let’s see how SQL Server uses this sliced-up, diced-up data to more rapidly find the rows you’re looking for. We’ll dig into the different reasons that columnstore indexes perform more […]
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.