Glossary

Report B (Customer balance trend analysis):

Likely bottleneck: Window function computation over 120 million rows, likely requiring a large sort operation. - Recommendation: Create an MQT that pre-aggregates monthly balance snapshots per customer. The window function can then operate on the smaller MQT (12 rows per customer instead of the raw

Learn More

Related Terms