on 09-26-2017 10:05 AM
Hi, I am trying to improve the performance of some HANA views that deal with huge amount of data (10's of millions of records).
Hierarchy of views is:
Base view (contain left outer join on Business Partner ID from Consumer account table to policy table) <---- policy129 view (contain left outer join between policy table and policy contract table)<---- policy 126 view(contain fields from policy contract table)
to improve performance I pushed down some calculations from join in base view to table in policy 126 view.
The execution time decreased from 500 sec to 350 sec but there is an exponential increase in memory from 20 GB to140 GB.
What all can be the possible reasons, and how can I start my analysis on the same.As plan viz don't help with memory consumption issues.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.