What are aggregating indexes, and how do they benefit performance?

“Firebolt's aggregating index pre-calculates and stores partial aggregation state for improved query performance, so a single index can serve many query shapes. The index is stored as an ordinary Firebolt table, partitioned and sorted on its grouping keys.”