SAP Message RS_DB_DB6020 - DB2/LUW: Index &1 deleted as not required

Diagnosis
The standard seconday index &V1& is not needed for this InfoCube andtherefore has been deleted.

System Response
Secondary indexes are created for all key fields of a fact table bydefault. However, in this case they are not necessary.
For example, field &V2& in the E-fact table of an InfoCubes which onlycontains cumulative key figures is the same for all data records. Asecondary index is not needed for this field and furthermore,maintaining the index for data manipulation operations such as INSERT,UPDATE and DELETE in the absence of proper selectivity, istime-consuming.
If a dimension is selected for multidimensional clustering, thesecondary index is not needed for the corresponding key field. A system-internal block index is created for the key field. This does not appearin the ABAP Dictionary.