In this article, our focus will be to test, the performance benefits of columnstore indexes, on a transactional (OLTP) workload, for real-time analytics.

We'll cover examples from each of the followings - Pivot, Aggregate Functions, Analytic Functions, Ranking Functions and Window Functions.