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

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022

E. PollackAnalytics Optimization with Columnstore Indexes in Microsoft SQL Serverhttps://doi.org/10.1007/978-1-4842-8048-5_2

2. Transactional vs. Analytic Workloads

Edward Pollack¹  

(1)

Albany, NY, USA

 

Transactional and analytic data are fundamentally different in terms of how they are written, read, stored, and managed. To achieve optimal performance of either type of data requires architecting data structures and software that cater to each of these paradigms.

Choosing the optimal data structure is critical in large, busy production systems as the cost to rebuild an existing system is significantly higher than to architect it effectively from the start. This ...