Optimization for report SLAs in Clustering Warehouse

Thoughts of Optimization for report SLAs. There are view created on top of tables which contains heave business logic

• Optimize data models inside the view
• Using SQL execution plan (Synapse / MSSQL)
• Data Movement in Cluster

CHANGELOG

• 2024-02-23: Init thought during dealing with performance issues

Key Notes

:fontawesome-brands-youtube:{ .youtube } What is video Made SQL script runs 10x faster

• Reduce Suffering and Broadcasting data can help to reduce execution time
• Due to multiple CTEs and Sub-Query, data have to be suffer and broadcast across database nodes`
• Try to avoid using
  • GROUP BY
  • JOIN
  • ORDER BY