Skip to Content
Some ABAPers might have already noticed this button “Graphical Explain” in tcode ST05 but do not know how to use it properly.
First you can switch on SQL trace via tcode ST05:
And execute the program you want to trace in another SAPGUI window. Once finished, deactivate the trace in ST05.
And press this button to display the trace.
Use this menu to export the execution plan of a given SQL statement into a local file (.plv ):
Then open it via HANA Studio:
Then the execution plan could be displayed in detail as a graph:
You can even paste the SQL statement you observed in ST05 into HANA Studio and execute it there:
Just open SQL Console, paste the source code and press F8 to execute:
To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

    1. Jerry Wang Post author

      Hi  Lars,

      Oh my god! I never remembered that I had read your blog in year 2013 🙁 Recently I was assigned with a performance tuning project so I start to learn HANA Studio a little bit, and wrote what I have learned daily into this blog.

      Since there is already comment on this blog, it is not possible for me to delete it. I notice that you are community moderator, do you have enough authorization to delete this blog? If so, would you please kindly do me a favor to remove it?

      Sorry for inconvenience caused and thanks a lot for your help!

      Best regards,

      Jerry

      (0) 
      1. Lars Breddemann

        Hi Jerry

        there’s not a problem here! Your blog post should definitively stay online.

        It is pretty clear that you didn’t mean to copy my blog and sell it as yours.

        So, all good mate! How about you share some of your experiences from the performance tuning project you mentioned?

        Cheers,

        Lars

        (0) 

Leave a Reply