cancel
Showing results for 
Search instead for 
Did you mean: 

Bex query is working slow although we have Aggregates and daily compression jobs

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member976
Active Contributor
0 Kudos

Hi,

find the SQL trace for the specific bex queries.

enter the TX- ST05

activate the trace deactivate the traces find the objects for aggregates need.

please find the doc it will help.

Thanks,

Phani.

Former Member
0 Kudos

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