(Pinal Dave) During the recent Comprehensive Database Performance Health Check, I noticed there were lots of aggregation going on with various data in the table. I suggested that the client can experiment with the columnstore indexes and it may help the performance.
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help