Index
A
AlwaysOn Availability Groups
Analytic data
characteristics
OLAP vs. OLTP data access patterns
size
structure
Analytic query pattern
Analytic sales order table
Analytic workloads
B
Backups
Batch mode execution
columnstore aggregation query
execution plan
clustered index scan
columnstore index
fact and dimension tables
performance discrepancies
row counts
row mode vs. batch mode operation
performance
query
Batch mode processing
Batch mode vs. row mode processing
Binary tree structure
Bit array compression
Brute-force approach
Bulk insert processes
Bulk loading
columnstore indexes
performance, columnstore indexes
processes
C
Clustered columnstore index
compressed segments
data storage
Clustered rowstore index
data storage
structure
Columnstore archive compression
Columnstore compression ...
Get Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
