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 comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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 comment
    10|10000 characters needed characters exceeded

    • What I would most like to do is reduce the size of the Index or at least explain why it is so large in relation to the data.

      Since it is an sap delivered cube used for "Front-End and OLAP Statistics (Details)" I hoped there was a process to maintain it better.