Skip to Content

Large /BI0/E0TCT_C02 table is mostly index

I recently began supporting a BW 731 system who's largest table is /BI0/E0TCT_C02 which is SAP Front-End and OLAP Statistics (Details) Table.

The table is 44gig of which 39Gig is made up of indexes and growing. It contains 129,949,145 rows.

I have had no luck finding a maintenance job to control this and appreciate any suggests folks might want to offer on how to get this under control and keep it there.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Dec 27, 2017 at 09:41 AM

    Hi William,

    What would you like to do exactly?

    If you want reduce the data in cube please go through below notes.

    1431315 - P24: Reduction of very large request lists in cubes and DSOs

    2146472 - FAQ for Report - RSSM_REDUCE_REQUESTLIST and RSSM_EXPAND_REQUESTLIST

    Reagrds,

    Prakash K

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.