Performance Tuning directly in the SAP System

The Index Advisor of SAP IQ determines on the basis of historic values which additional index would further optimize the database access. This can be created directly.

List according to used and unused indices. This generates a checklist of the indices actually being used, enabling you to see which you can delete.

After selecting “NLS DB Indices” a list of all indices and the corresponding detail information of a nearline table is displayed.

The removal of SAP data into a nearline database such as SAP IQ is part of a strategic Information Lifecycle Management (ILM) concept. The PBS nearline solutions for SAP BW and also for SAP ERP enable both the archiving of the data in a nearline database as well as its analysis. Access to the nearline data is already very fast thanks to the column-oriented database technology of SAP IQ. Additional database indices can accelerate analyses even further. The administrative transactions required for this can be executed extremely fast and without great effort.

The creation, monitoring, and deletion of such additional SAP IQ indices can be performed easily using via the NLS Monitor directly in the SAP system. Here you can find the SAP IQ-specific Index Advisor that you can use to analyze and monitor the database accesses. It shows which additional indices can be used to further improve access to the nearline data. You can create the index suggested by the Index Advisor via a simple click in SAP IQ.

Additional indexing is frequently used for extremely large IQ tables in order to further accelerate reporting. A further advantage can be found in the increased performance of IQ installations in which only limited main memory and CPU resources are provided due to cost reasons. Reduced runtimes – that would otherwise only be possible through an increased use of memory or CPU kernels – can be achieved as a result of the additional indexing.

SAP BW

BW 7.0 BW 7.3 BW 7.4 BW 7.5
CBW for SAP NLS Verfügbar InfoCubes, DSO and PSA
Verfügbar InfoCubes, DSO and PSA
Verfügbar InfoCubes, DSO and PSA
Verfügbar aDSO
Verfügbar InfoCubes, DSO and PSA
CBW NLS IQ Verfügbar InfoCubes, DSO and PSA
Verfügbar InfoCubes, DSO and PSA
Verfügbar InfoCubes, DSO and PSA
Verfügbar InfoCubes, DSO and PSA
Verfügbar aDSO

SAP ERP

ECC 6.0 ECC 6.17
Nearline Analytic Infrastructure Verfügbar Independent
Verfügbar Independent

S4HANA

S/4HANA 1610
Nearline Analytic Infrastructure In Entwicklung Independent



  Available
  Available (with NAI Functionality)
  In development