SAP HANA 2.0 Administration · Performance Analysis: SQL Tuning & Plan Analysis

What is the syntax of SAP HANA EXPLAIN PLAN, including the option to plan a cached statement?

The full answer is available in the KnowCard app, with spaced-repetition review and AI explanations.

Get the answer in the app

More in Performance Analysis: SQL Tuning & Plan Analysis

What is the SAP HANA SQL plan cache, and what happens when a statement is executed?

In which direction should you read an SAP HANA execution plan, and which columns reconstruct the operation sequence?

What information appears on the Overview tab of an SAP HANA PlanViz visualized plan?

How can you restrict the SAP HANA expensive-statements trace, and what wildcard/exclusion syntax applies?

Which SAP HANA metadata views expose optimizer statistics, and what is special about querying M_SYSTEM_DATA_STATISTICS?

In SAP HANA, why is 'execution plan' the preferred term over 'explain plan' or 'query plan'?