How can you identify often-used SQL statements? Note: 2 correct answers

The correct answer is A. Review the SQL Plan Cache subtab in the Performance tab of the SAP HANA studio Administration editor B. Create an SQL query on the view SYS.M_SQL_PLAN_CACHE. See the full explanation below for the reasoning.

Question

Options

AReview the SQL Plan Cache subtab in the Performance tab of the SAP HANA studio Administration editor
BCreate an SQL query on the view SYS.M_SQL_PLAN_CACHE
CReview the Sessions subtab in the Performance tab of the SAP HANA studio Administration editor
DCreate an SQL query on the view SYS.M_CONNECTION_STATISTICS

How the community answered

(24 responses)

A
71% (17)
C
8% (2)
D
21% (5)

Community Discussion

No community discussion yet for this question.

Full C_HANASUP_1 Practice