on 08-14-2014 3:18 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
9 | |
9 | |
7 | |
7 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.