RSORAISQN SAP Report – Index Storage Quality Analysis

RSORAISQN is a standard ABAP report available within your SAP system.This report performs mass storage analysis and defragmentations of indexes of the SAP system’s database.

Let’s try together ;

SE38 –> RSORAISQN

RSORAISQN SAP Report - Index Storage Quality Analysis

Execute – F8

For an example we are going to check table “BALDAT”

Select “Start Workingset” and check “Analyze”

RSORAISQN SAP Report - Index Storage Quality Analysis

Execute – F8

RSORAISQN SAP Report - Index Storage Quality Analysis

OK

After that you should get the info like below

RSORAISQN SAP Report - Index Storage Quality Analysis

Now select “Show History”

RSORAISQN SAP Report - Index Storage Quality Analysis

Execute – F8

You will get the detail info about the index like below screen

RSORAISQN SAP Report - Index Storage Quality Analysis

Now select “Start Workset” with “Defragment” – “Rebuild Online” checks

RSORAISQN SAP Report - Index Storage Quality Analysis

Execute – F8

You will get the following message again

RSORAISQN SAP Report - Index Storage Quality Analysis

After that let’s check and compare the results again with “Show History”

RSORAISQN SAP Report - Index Storage Quality Analysis

Execute – F8

Finally you will get the following screen that shows the detail information about the index before and after the Rebuild operation.

RSORAISQN SAP Report - Index Storage Quality Analysis

If your index quality to be below 60% then please follow the rebuild steps.

Leave a Reply


1 × = five

Blogroll