Statistics for Maintenance Processes in SAP HANA Indexes
Use
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.
Prerequisites
The statistics have to be switched on for the relevant InfoProviders. You make this setting on the statistics properties maintenance screen (choose 
Tools 
Settings for BW Statistics
on the Data Warehousing Workbench screen). For more information, see Maintenance of Statistics Properties.
Features
Statistics 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 |