Skip to Content
avatar image
Former Member

Query Optimization using Aggregates

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 07, 2015 at 03:24 PM

    Hi,

    you need to find the trace in ST05.

    first activate the trace  -> then execute the query at RSRT -> after query exection compeleted deactive the trace -> now read the select statement.

    based on the select statement you will decide the which object required for the aggegates ot not.

    plase read the document for more detail.

    How to find SQL Traces

    Thanks,

    Phani.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Chanda Janardhan sudhir Kumar

      Hi Chandra,

      Thanks for ur reply, as i went to execute+debug and selected the display aggregate and a list appear ..

      I can see a list of objects that are present under maintain aggregate of infocube and some other object is also displayed.

      do i need to build aggregate on these "other objects".

      Also Can you please elaborate on your statment:

      If for any cube it does not hit, you can take screen shot and create an aggregate based on the characteristics shown ."

  • Jan 08, 2015 at 07:07 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded