on 06-18-2014 6:25 AM
Hi All,
Bex query is working slow although we have Aggregates and daily compression jobs and re partitioning
The present query properties in RSRT are
cache mode : 5
Read mode : H
infoprovider grouping : Zero
optimization mode : zero
Please suggest how else i can improve query performance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Pls check DB index, Aggr index and Statistic are maintained properly or not.
This you can check from performance tab of cube,
If all Ok then you can try some permutation combination on rsrt for parallel procesing, seelction of element....
I assume you are already using filters and relevant conditions in query to see specific data only.
Also please search on performance improvement of query, will get lots of other ideas/documets.
Regards,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
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.