Query Optimization using Aggregates

[Former Member]

Hi Folks

We have a performance tunning activity in which we need to optimize the query running time using aaggregates. The aggregates are already present in the system. I need to find to find out what more aggregates can i create or delete the existing non-usable aggregate.

I have taken the list of the long running query and there multiprovider from the t-code st03.

Can you please guide me how to procede forward in this regard.

Regards

Nitin

[KodandaPani_KV]

Hi,

you need to check the aggregates being used or not in RSRT + Execute +Debug

and check the aggregates panle - selec the cube -> right clcik -> select the maintain aggregates.

now you will find the column as USED - then it says last used aggregates for the cube.

Thanks,

Phani.