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

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