To get an overview of the runtimes of specific subprocesses in SAP NetWeaver BW Accelerator index maintenance, you can display table RSDDSTATTREX.
For the following processes, the system writes the runtimes of specific subprocesses to this statistics table:
for initial indexing (see Indexing BW Data in SAP NetWeaver BW Accelerator )
Rollup (see Rolling Up Data to a SAP NetWeaver BW Accelerator Index )
Modifications after change runs (see System Response Upon Changes to Data: SAP NetWeaver Index ))
Some BW accelerator-specific tests in the analysis and repair environment work with statistical data (see Tests for BWA Indexes in the Transaction RSRV , Tests: Propose Delta Index for Indexes , Compare Size of Fact Tables with Fact Index ).
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 theThe 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 BW 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 of Commit Optimize |
REC_INSERTED |
Number of indexed records |
TSTPNM |
User |
TIMESTMP |
Start time stamp |