Analytics Optimization with Columnstore Indexes in Microsoft SQL Server Optimizing OLAP Workloads
You will learn when columnstore indexes should be used, and the performance gains that you can expect. You will also become familiar with best practices around architecture, implementation, and maintenance. Finally, you will know the limitations and common pitfalls to be aware of and avoid. As analy...
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
Berkeley, CA
Apress
2022, 2022
|
| Edition: | 1st ed. 2022 |
| Subjects: | |
| Online Access: | |
| Collection: | Springer eBooks 2005- - Collection details see MPG.ReNa |
Table of Contents:
- 1. Introduction to Analytic Data in a Transactional Database
- 2. Transactional vs. Analytic Workloads
- 3. What are Columnstore Indexes?
- 4. Columnstore Index Architecture
- 5. Columnstore Compression
- 6. Columnstore Metadata
- 7. Batch Execution
- 8. Bulk Loading Data
- 9. Delete and Update Operations
- 10. Segment and Rowgroup Elimination
- 11. Partitioning
- 12. Non-Clustered Columnstore Indexes on Rowstore Tables
- 13. Non-Clustered Rowstore Indexes on Columnstore Tables
- 14. Columnstore Index Maintenance
- 15. Columnstore Index Performance