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. |