Using aggregated in SAP HANA

SAP HANA is an in-memory database so all data resides in memory all the time and hence all calculations and functions can happen directly and hence materialized aggregations are not required in SAP HANA database.

With the use of column store, data is available vertically and hence operations on different columns can be easily performed.