cancel
Showing results for 
Search instead for 
Did you mean: 

HANA Calculation View poor performance with COUNT(*)

Former Member
0 Kudos

Hi,

We've calculation view which combines transaction data with master data attribute tables using LEFT OUTER JOIN. Transaction data table has approx. 800+ million records. If I run COUNT(*) on transaction data table, it returns the result in less than 3 sec. If I perform COUNT(*) on calculation view, it runs forever and fails with memory allocation. It seems like COUNT(*) is done after selecting entire dataset (800+ million records) and executing all JOINS.

Has anyone come across similar issue and any pointers for performance improvement with COUNT(*)?

Thanks,

Milind

lbreddemann
Active Contributor
0 Kudos

This question lacks all the relevant detail information. How does the calculation model look like? What are the differences in the PlanViz for both query variants? What HANA version are you using? Has the join cardinality been defined for the LEFT OUTER join?

To me, it looks like no research into this problem has been done so far.

Accepted Solutions (0)

Answers (0)