What are the Tables or Views running behind Visualization plan ?

[former_member462348]

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 ??

.

[lbreddemann]

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.