Analytics optimization with columnstore indexes in Microsoft SQL Server optimizing OLAP workloads
Meet the challenge of storing and accessing analytic data in SQL Server in a fast and performant manner. This book illustrates how columnstore indexes can provide an ideal solution for storing analytic data that leads to faster performing analytic queries and the ability to ask and answer business i...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
New York, New York :
Apress L. P.
[2022]
|
| Edición: | [First edition] |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009652826706719 |
Tabla de Contenidos:
- 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
