I have come to understand the importance of using columnstore indexes when my queries are aggregating and scanning across many millions of rows.
Azure SQL Database and Columnstore Indexes
1
I have come to understand the importance of using columnstore indexes when my queries are aggregating and scanning across many millions of rows.