SAP Message RSD_TREX518 - Compare size of InfoCube fact table with fact index

Description
The test calculates the number of records in the two Fact tables (E andF table) of the InfoCube and compares them with the number of records inthe Fact index of the BIA index.
If the number of records in the BIA index is significantly larger (> 10%) than in the InfoCube, query performance can be improved by rebuildingBIA index.
A difference in the number of records can have the following reasons:

  • After the BIA index was built, the InfoCube was compressed. Since the
    • BIA index is not compressed, it can contain more records than theInfoCube.
    • After the BIA index was built, requests were deleted from the InfoCube.
      • The requests are only deleted from the BIA index in the packagedimension. The records in the Fact index are therefore no longerreferenced. They are no longer taken into consideration when executingthe query, but not deleted.
      Note that the database statistics for calculating the size of theFact tables must be up to date since this test uses the databasestatistics of the tables and does not count them again.

      Repair
      It is not mandatory to rebuild the indexes, but this could beadvantageous if there is a large difference.