cancel
Showing results for 
Search instead for 
Did you mean: 

partitioning on caluclation view

Former Member
0 Kudos

Hi,

Can we do hash partitioning on Caluclation view internal table stored in "_SYS_BIC" to increase the performance ?

At the moment we are getting column store memory error while doing data preview however reports are running fine.

Regards

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

No, you cannot partition views, only tables. You can break a view up into multiple legs with filters to force parallelization.

If the reports run fine then ignore Data Preview. It materializes the whole view, which can cause memory errors if the view is very large.

Former Member
0 Kudos

Thanks for your clarification John...

Answers (0)