Visualize plan and explain plan

[Former Member]

Hello Gurus,

I need to understand the use of Visual Plan and Explain plan.

1) How to read them?

2) Any further system tables which can be used

3) Step by Step procedure to understand

4) Need to understand thoroughly and master in that so that I can increase the performance of my components, sql-scripts, procedures.

Thanks in advance.

Shirish.

[vivekbhoj · Accepted solution]

Hi Shirish,

It would be better if you go through HANA Performance Guide first:

http://help.sap.com/hana/SAP_HANA_Troubleshooting_and_Performance_Analysis_Guide_en.pdf

Regards,

Vivek