Skip to Content

What are the Tables or Views running behind Visualization plan ?

Hi All,

Would like to know what are the System Tables or Views which gets executed when we run the Visualization plan for any calculation views.

For Example: When I Execute the Visualization Plan for a Calculation View i could see some memory is allocated and would like to know whether these details are stored in HANA to perform some analysis on Memory level ??

.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Feb 07, 2019 at 11:09 PM

    The information presented in PlanViz is not based on data in system tables/views. Instead, PlanViz is a trace of specific command execution(s). The data is gathered by internal HANA functions and handed over to the tracing session via an internal stored procedure interface. The client receives an XML formed BLOB containing the data.

    This is basically what you find when you open the .PLV file with a text editor.

    So, this level of detail (query operator level) is not available in any other system table.

    A commonly good enough starting point is to use the EXPLAIN PLAN function instead. While it does not show actual memory allocation, checking on expected number of records per operation often can provide a hint towards query optimization.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.