Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads by Pollack, Edward
Roll over image to zoom in Click on image to zoom
Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads by Pollack, Edward

Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads

Apress
Price:
$54.99

Description

1. Introduction to Analytic Data in a Transactional Database2. Transactional vs. Analytic Workloads3. What are Columnstore Indexes?4. Columnstore Index Architecture5. Columnstore Compression6. Columnstore Metadata7. Batch Execution8. Bulk Loading Data9. Delete and Update Operations10. Segment and Rowgroup Elimination11. Partitioning12. Non-Clustered Columnstore Indexes on Rowstore Tables13. Non-Clustered Rowstore Indexes on Columnstore Tables14. Columnstore Index Maintenance15. Columnstore Index Performance

Author: Edward Pollack
Publisher: Apress
Published: 03/13/2022
Pages: 302
Binding Type: Paperback
Weight: 1.16lbs
Size: 10.00h x 7.00w x 0.63d
ISBN13: 9781484280478
ISBN10: 1484280474
BISAC Categories:
- Computers | Database Administration & Management
- Computers | Programming | Microsoft

This title is not returnable