To acquire an overview of the runtimes of specific subprocesses in SAP HANA/BWA index maintenance, you can display table RSDDSTATTREX. If you are using the SAP HANA database, the same parameters are relevant as when using any other database with an SAP HANA. Not all subprocesses are relevant however. You can use the same statistics for the relevant subprocesses (for the SAP HANA database) as you use for a BWA.
In terms of the SAP HANA indexes, the system writes the runtimes for the initial indexing process to the statistics table.
The statistics have to be switched on for the relevant InfoProviders. You make this setting on the statistics properties maintenance screen (choose Data Warehousing Workbench screen). For more information, see Maintenance of Statistics Properties.
on theStatistics table RSDDSTATTREX contains the following information for each table that is indexed:
Column |
Description |
---|---|
STATUID |
Unique identification key |
TABLNM |
Table Name |
CHANGEMODE |
Specifies whether the process is part of a rebuild ("N") |
FILLMODE |
Fill mode Full ("F") or delta ("D") |
TIMEACTIVATE |
Time of activation |
TIMEREAD |
Time required to read data from the database |
TIMEFILL |
Time required for packing and indexing |
TIMEOPTIMIZE |
Time for Prepare Optimize |
TIMECOMMIT |
Time of Commit Optimize |
REC_INSERTED |
Number of indexed records |
TSTPNM |
User |
TIMESTMP |
Start time stamp |