on 07-27-2006 11:52 PM
Hi
What are the tables related to see Statistics for Maintenance Processes of a BI Accelerator Index .
thanks
Laurel
Hello
To get an overview of the runtimes of specific subprocesses in BI accelerator index maintenance, you can display the <b>RSDDSTATTREX</b> table.
For the following processes, the system writes the runtimes of specific subprocesses to this statistics table:
1)Initial indexing (see Using the BIA Index Maintenance Wizard)
2)Rollup (see Rolling Up Data in BI Accelerator Indexes)
3)Modifications after change runs (see System Response Upon Changes to Data: BI Accelerator Index)
<b>Prerequisites</b>
The statistics have to be switched on for the relevant InfoProviders. You make this setting in statistics properties maintenance on the Data Warehousing Workbench screen, choose Tools-->Settings for BI Statistics
Hope it Helps
Chetan
@CP..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.