8,364 views
2 years ago
10,287 views
1 year ago
Microsoft Azure
313K subscribers
Tags
Davide Mauri
Lara Rubbelke
columnstore
query performance
Azure SQL DB
Azure SQL Database
rowstore
rowgroup
column segment
clustered columnstore index
delta rowgroup
deltastore
batch mode execution
LAG operator
when to use
CREATE COLUMNSTORE INDEX
compression
clustered
ordered
nonclustered
b-tree indexes
heap
bulk loading
trickle insert
filtered indexes
hot data
warm data
execution plan
index fragmentation
page density
maintenance
rebuild
partition
6 Comments