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 Start of the navigation path Tools Next navigation step Settings for BW Statistics End of the navigation path 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