RSORAISQN - Report for improving index Quality in Oracle DB

Hi All,

In this post, I will show users to use SAP report RSORAISQN to improve the index quality of table in Oracle DB. Here we are taking an example of MSEG Table. You can similarly check the index quality of any SAP table.

Note: Please use this report during Off-Peak business hours.

Login to SAP System with appropriate user rights to execute reports.

TX : Se38 - RSORAISQN - Execute.

Step 1: Analysis

You will find a screen as shown below:

Enter the detail as shown in the above example.
Finally Click on execute button and it will ask for a confirmation popup, click "Ok" on that screen.

Step2 : Checking Quality

Once step 1 is done, it will bring you to the main screen as shown above.

Now Enter the detail as shown below to check the index quality of the MSEG table.

And Click on "Execute" button.


The below screen shows, the index quality to of MSEG Table(Example)

If you find index quality to be below 60%, please follow the Step 4 to rebuild it.

Step 3: Improving Index Quality

You can enter the detail as shown below. Please make sure that your ID should be same during analysis.
And click on execute button.

Once, you rebuild the index, you can check to it using Step1 and Step2.

Thanks,
Sharib Tasneem