While using the standard functionality in RSA1 to update / repair DB indexes for a Profitability Analysis infocube, 3 steps needs to be follow:
1. Check DB indexes
2. Delete DB indexes
3. Repair DB indexes
The problem comes when the system tries to delete / repair the indexes whereby it will run too long and finally, we need to "kill" the process by cancelling it. This happens in QA server. While testing it in Development server, it runs well.
I have scan the SQL statement behind the 3 process above using tcode SM50 and submit these statements via ABAP program withing EXEC SQL ..... ENDEXEC. This program, when executed in QA server it will still gives a long execution time. When one of the index won't be able to delete, the next step (repair) will fail as well.
What is the reason of the above issue? Can anyone help?