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...
| Other Authors: | |
|---|---|
| Format: | eBook |
| Language: | Inglés |
| Published: |
New York, New York :
Apress L. P.
[2022]
|
| Edition: | [First edition] |
| Subjects: | |
| See on Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009652826706719 |
| Summary: | 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 intelligence questions with alacrity. The book provides a complete walk through of columnstore indexing that encompasses an introduction, best practices, hands-on demonstrations, explanations of common mistakes, and presents a detailed architecture that is suitable for professionals of all skill levels. |
|---|---|
| Item Description: | Includes index. |
| Physical Description: | 1 online resource (285 pages) : illustrations |
| Bibliography: | Includes index. |
| ISBN: | 9781484280485 |
