Automating SQL Plan Management with SQL Plan Advisor

Objective

After completing this lesson, you will be able to analyze the internal workings of SAP Plan Advisor to recommend solutions for performance drops using SQL Plan Stability and Plan Variant.

Content

Lesson Summary

  • Explain how SQL Plan Advisor automates query optimization by detecting and addressing performance issues.
  • Describe how SQL Plan Advisor tests alternate SQL plans to identify improvements and ensure stability in HEX environments.
  • Outline how SQL Plan Advisor identifies performance degradation, searches for improved plans, and applies the best option.
  • Summarize the interaction between SQL Plan Advisor and SQL Plan Stability, highlighting the use of historical statistics and the generation of updated test statistics.
  • Navigate the SQL Plan Advisor application within SAP HANA Cloud Central to identify queries flagged for performance degradation and initiate testing.
  • Recognize the role of SQL Plan Advisor in automating SQL Plan Management and its contribution to the evolution of query optimization.

Learning

SAP FacebookSAP YoutubeSAP LinkedIn