# Summary Of Aggregation Operations Case Studies


![center](./student-guide/diagram/01-45-1.png)

------------------------------------------------------------

Summary

When we perform aggregation statistics operations, we should ensure proper indexes, avoid large data scans or even full table scan, consider the system's affordability, and avoid aggregation operations crushing the database out of performance problems in large concurrent aggregation scenario.