BRSPACE to compress all the index

[Former Member]

Dear expert,

Currently , no table no index is compressed in our ECC.

So we want to first compress all the index then later will thinking about compress the TOP 20 tables.

i would like to run the following scripts

brspace -u / -c force -f idrebuild -o sapsr3 -s PSAPSR3 -i allsel -c cind -ic ora_proc -p 4

But do you suggest i'd rather compress all the index by brspace table reorg?

Do you suggest i run the index compression directly on productive system ？

Thank you!

[former_member188883]

Hi Kate,

You can perform index compression online on Production provided you are performing it during low load period as it may impact performance.

Refer SAP note for more details on the options available with brtools to perform index compression

1464156 - Support for index compression in BRSPACE 7.20

Alternate option is available.

You may perform table compression which will automatically rebuild all the indexes for that table. Refer SAP note

1907700 - Different approach to compress tables

Hope this helps.

Regards,

Deepak Kori