Skip to Content
0
Former Member
Aug 23, 2005 at 06:07 PM

Index Maintenance

64 Views

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.