You can use report RSORAISQ to examine the indexes in the system and save a history of the analyses performed. You can use the data saved in this way to develop a strategy for your system and develop a plan as to when certain indexes should be rebuilt (either on a regular basis or after certain administrative tasks have been performed).
Possible reasons for the rebuild
• You want to release the unused space again.
• Accesses to the object are slow or consume an unnecessary amount of database resources (high number of get buffers).
Report RSORAISQ provides the following functions:
• Analysis of the memory quality of one or more indexes
• Display of indexes that have already been analyzed
• Rebuild of one or more indexes
Reference:
• SAP Note 712098.
• RSORAISQ is now replaced by RSORAISQN.
