Skip to Content
avatar image
Former Member

Index compression for Oracle for SAP BI system

HI,

We are trying to find out how we can set Index compression on out BI system, already we did for Index compression on ECC as per Note 1109743.

Is anyone faced any experience on BI Oracle index compression?

we are using BI 700, Oracle 11g on Windows.

Thanks


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 09, 2012 at 11:14 AM

    Hi Yograj,

    yes i have introduced the index key compression in BI systems as well. You can only compress B*Tree indexes, so you are not able to compress most of the indexes in a SAP BI system.

    However the procedure is the same as for an ECC system. Find the biggest B*Tree indexes and compress them. Maybe there are some B*Tree indexes, that are recreated by process chains - it makes no sense to compress these, because of they will lose their compress attributes.

    Best Regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Mark/Stefan,

      SAP Note 1464156, is more helpful, I did work on "ctabind - compress tables and indexes".

      Thanks

  • avatar image
    Former Member
    Jul 09, 2012 at 07:32 AM

    Hello Yograj,

    the easiest way would be to use brspace. See SAP note 1464156 for details:

    https://service.sap.com/sap/support/notes/1464156

    Index compression comes for free and it can be implemented online. On the other side I could hardly see any improvements for performance, but the space savings alone justify compressing the BW indexes.


    Regards,

    Mark

    Add comment
    10|10000 characters needed characters exceeded