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.