Skip to Content
author's profile photo Former Member
Former Member

Index Maintenance

In my update rules for loading GL I have a routine that essentially performs a lookup to another AP ODS. Initially the performance of loading the GL was very poor until I added an index to the AP ODS using transaction SE11. This new index was a HUGE perfomance improvement!!

Now it has been a couple of months and I've been asked to reload the GL. Unfortunately the performance is once again TERRIBLE! It is almost as though the indices no longer exist yet when I look at transaction SE11 they are clearly still there.

MY QUESTION:

Just because the indices still exist does necessarily mean that the indices are being updated regularly? How often would each index be updated? I suspect maybe they have never been updated but don't know how to determine this.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Aug 23, 2005 at 06:17 PM

    Hi Patrick,

    Index existance is only a necessary condition for a good performance ... but if index's statistics are out of date performance can be very poor. So the solution is very simple: update statistics on a regular basis.

    You can run statistics with ABAP report (RSANAORA on ORACLE DB, for example).

    To have a clear evidence of the performance gain trace the SQL access (ST05) before statistics update and after

    Hope it helps

    GFV

    P.S. In BW 3.x ODS index maintenance in integrated in RSA1, so no need to use SE11 (these indexes can't be transported)

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Patrick,

      in BW 3.x it's better to use ODS builing functionalities (try to Modify and see at the bottom of the screen) instead of SE11. in BW 2.x it was missing ...

      Once you built the index there's no need to rebuild: the underying DB contines to update the index while you modify data (the DB does not perform Statistics Update by itself ...)

      But what you need to do is Updating Statistics: this activity should be done after each relevant data update (not for few records ...).

      To have a clearer idea about indexes and statistics generally I do compare indexes to streets and statistics to maps. To find the suitable route the maps are very usefull! Another example can be the index of an encyclopedia: it's easy to use and to find pages, if you know that B comes after A and before C ... In this example the Statistic is the A-Z order!

      Ask your DBAdm for a clearer explanation about.

      With InfoCubes -> Manage / Performance you see that Index and Statistics maintenance are two different and separated activities: in ODSs there isn't the same tabstrip so you should carry out it "manually".

      Hope it helps (and if so don't forget to assign points!)

      GFV

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2005 at 08:35 PM

    Patrick,

    Try analysing the indices using RSRV->database-> database indices for infocube and its aggregates and database parameters.

    Also, try unchecking the reporting capabilities for the ODS if you are not using it for reporting purposes.

    Hope this helps.....

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 24, 2005 at 08:04 PM

    in my opinion, the indexes of an ods are only build up during activation of new data. i don't know if you can rebuild the index with already active data.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.