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…

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...
Menu
{"cart_token":"","hash":"","cart_data":""}