Statistics for Maintenance Processes of SAP NetWeaver BI Accelerator Indexes

Use

To get an overview of the runtimes of specific subprocesses in SAP NetWeaver BI accelerator index maintenance, you can display the RSDDSTATTREX table.

For the following processes, the system writes the runtimes of specific subprocesses to this statistics table:

●      Initial indexing (see Using the BIA Index Maintenance Wizard)

●      Rollup (see Rolling Up Data in SAP NetWeaver BI Accelerator Indexes)

●      Modifications after change runs (see System Response Upon Changes to Data: SAP NetWeaver BI Accelerator Index)

Integration

Some BI accelerator tests in the analysis and repair environment work with statistics data (see Checking SAP NetWeaver BI Accelerator Indexes (Transaction RSRV), tests: Propose Delta Index for Indexes, Compare Size of Fact Tables with Fact Index).

Prerequisites

The statistics have to be switched on for the relevant InfoProviders. You make this setting in statistics properties maintenance screen (on the Data Warehousing Workbench screen, choose Tools ®  Settings for BI Statistics). For more information, see Maintenance of Statistics Properties.

Features

The statistics table contains the following information for each table that is indexed:

RSDDSTATTREX

Column	Description
STATUID	Unique identification key
TABLNM	Table name
CHANGEMODE	Specifies whether the process is part of a BI accelerator rebuild ("N"), the rollup ("R") or a modification after a change run ("C").
FILLMODE	Fill Mode: Full ("F"), delta ("D") or change run ("C")
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 for Commit Optimize
REC_INSERTED	Number of indexed records
TSTPNM	User
TIMESTMP	Start time stamp