m_expensive_statements - operation

[Former Member]

Hello,

When I look at m_expensive_statements I can see that for each SQL that is executed the system generates 2 records in m_expensive_statements view:

1. With operation = select

2. With operation = AGGREGATED_EXECUTION

Both records have very similar time stamp (it looks like they are running in parallel)

Does it means that for each BO query the system is using the memory summation of both lines? Why only in the AGGREGATED_EXECUTION we get the number of records?

Thanks,

Amir

[sascha_schwedes]

Hi,

please check  M_EXPENSIVE_STATEMENTS - SAP HANA SQL and System Views Reference - SAP Library.

Regards, Sascha

[Former Member]

Hello,

Amir Dror did you find answer?

[Former Member]

Hi Anna,

Which version of SAP HANA are you using?

I am executing this SELECT on SPS11 and do not find any duplicate records

Sunil

[Former Member]

The same, SPS11