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'?

What are the five tabs below a SAP HANA PlanViz plan, and which is relevant only for multinode systems?

How is the SAP HANA expensive statements trace enabled, and which three threshold parameters define 'expensive'?

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

Why is the SAP HANA Studio load graph no longer the primary monitoring tool, and what online monitor remains?

What does the EXECUTION_ENGINE column of an SAP HANA execution plan reveal, and why does it matter for tuning?

What must you do before displaying an ST05 SQL trace, and what is the default record limit?

How are user-defined statistics created in SAP HANA, and what is a 'sketch'?

When disabling a single SAP HANA expensive-statement threshold, what value should you use and which value must you avoid?

For which SQL statement types is SAP HANA EXPLAIN PLAN allowed?

How long does SAP HANA keep load-history data in the M_LOAD_HISTORY_* views, and which parameters control the collection?

What happens to the SAP HANA M_LOAD_HISTORY_HOST/SERVICE views after a failover in a replicated system?

Why are optimizer statistics less critical in SAP HANA than in traditional relational databases?

What is the difference between inclusive time and exclusive time for a PlanViz plan operator in SAP HANA?

What file format does SAP HANA PlanViz (Plan Visualizer) produce, and what does it contain?

What two major activities make up SAP HANA performance management?

Which parameter sets the SAP HANA SQL plan cache size, and what is its default?

Why does PlanViz fetch all rows (ignoring the SAP HANA Studio 1,000-row limit)?

What is the status of plan pinning in SAP HANA 2.0, and how does it differ from statement hints?

What is SAP's rule of thumb for sizing the SQL plan cache of a non-ABAP system on SAP HANA?

What are statement hints in SAP HANA, and how do they differ from explicitly coded hints?

Which two SAP HANA monitoring views provide the data behind the cockpit performance charts, and how do they differ?

What is the STATEMENT_HASH column in the SAP HANA M_SQL_PLAN_CACHE view, and what is it used for?

In a SAP HANA PlanViz plan operator name, what do the first two letters indicate — e.g., the JE in JEAggregate?

How is optimizer statistics maintenance handled in SAP HANA compared with other databases?

What is materialization in an SAP HANA execution plan, and why is late materialization more efficient than early?

What is the difference between PlanViz 'Visualize Plan > Execute' and 'Prepare' in SAP HANA?

What is eager eviction in the SAP HANA SQL plan cache, and which parameter and values control it?

Which two SAP HANA parameters must be enabled for the execution-time and memory averages in M_SQL_PLAN_CACHE to be populated?

What is SAP's rule of thumb for sizing the SQL plan cache of an ABAP system on SAP HANA?

Where is longer-term SAP HANA load history stored, and what are its retention and interval?

Why do ABAP SQL statements with WHERE-clause variables (shown as '?') reuse a single SAP HANA execution plan?

Which DBACOCKPIT performance functions help analyze expensive SQL on SAP NetWeaver / S/4HANA, and what is the default expensive-statements list?

In SAP HANA expensive-statement tracing, what does the `trace_parameter_values` parameter control, and what is its default?

What do the <ALL> and <ENFORCE> server-name options mean when activating an ST05 trace with a filter?

Which monitoring view shows SAP HANA SQL plan cache statistics, and which columns matter for sizing?

In an SAP HANA EXPLAIN_PLAN_TABLE, what does a NULL value in the TABLE_NAME column indicate?

What are the two types of optimizer statistics in SAP HANA, and how do join statistics behave?

How does the SAP HANA M_SQL_PLAN_STATISTICS view differ from M_SQL_PLAN_CACHE?

In the ST05 trace display, what does the Explain function do for an SAP HANA statement?

What does the SAP HANA EXPLAIN PLAN statement do, and where does it store its result?

What is transaction ST05, and how does it relate to the SAP HANA SQL trace?

Which SAP HANA monitoring view holds metainformation (not measurements) about the load-history views, and which column reveals the data source?

Why should an ST05 SQL trace be kept short, and which profile parameter controls the trace file size?

Which tool is required to analyze a SAP HANA PlanViz visualized plan, and what is PlanViz?