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_1

1. Introduction to Analytic Data in a Transactional Database

Edward Pollack¹  

(1)

Albany, NY, USA

 

Analytic data, by its nature, can be large and challenging to maintain and can grow quickly over time. Similarly, its use increases with time as analysts and data scientists find more ways to crunch it. There is a great convenience to having analytic data in close proximity to its underlying transactional sources. Utility is also gained by choosing a location for analytic data that can withstand the test of time, thus avoiding the need for ...