This article was first published on: 2020-03-14. This article will probe 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.