SQL Plan visualization

[Former Member]

Hello,

I'm trying to choose the visualize plan option on Performance - SQL Plan cache but I'm getting this error:

What can I do for execute it correctly?

Regards

[lbreddemann]

The SQL plan cache overview includes statements from the XS engine and the statistics server/service.

These statements are processed differently in SAP HANA than 'normal' SQL commands that you can run via ODBC or JDBC connection in the indexserver.

Planviz and explain plan are only available for statements that run in the indexserver.

So, to 'fix' the issue, just pick a statement that has been run in the indexserver (check the service port number in the list) and run PlanViz on this statement then.

[Former Member]

Can you execute the SQL statement in the SQL console?

If yes, then type out your query and then select the query like how you normally select text in a text editor, then right click -> Visualize plan -> Execute.

I am not very sure what you could do if the query cannot be executed in the SQL console.

[Former Member]

Yes, I can execute queries on SQL console.

But I can see the visualize plan of a querie executed on a hana tenant database used like classic 3-tier architecture.

I don't want to execute again a querie executed by users on production system

Regards