performance of query

[Former Member]

Hi BW Experts

when i try to execute the query it taking lot of time but this cube(0FIAR_C03) contains 6crore records .i created aggregate on this cube and iam deleting and recreating index also but no good performance .even iam entering small selection period also . i gone through previous forums but i did'nt get any solution.Can you please guide me any one on this issue.

Regards

RK

[Former Member · Accepted solution]

Hi RK,

first try to get the statistics of the query through

TX- st03,rsrt

Database table : rsddstat

depending upon database reading time,front end time try to take corrective actions.

http://www.dmreview.com/issues/20051001/1038109-1.html

http://www.sap.com/platform/netweaver/pdf/BWP_AR_IDC_BI_Accelerator.pdf

/people/andreas.vogel/blog/2007/03/16/how-to-read-st03n-datasets-from-db

/people/andreas.vogel/blog/2007/04/08/statistical-records-part-4-how-to-read-st03n-datasets-from-db-in-nw2004

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/60cecb1d-0a01-0010-8289-b14fd990...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/1e553368-0601-0010-49ab-c429607f...

Regards,

Vijay.

[Former Member · Accepted solution]

HI,

thank you very much for your reply

regards

RK