Index compression for Oracle for SAP BI system

[Former Member]

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

[stefan_koehler · Accepted solution]

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

[Former Member · Accepted solution]

Thanks Mark/Stefan,

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

Thanks

[Former Member]

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