Note 1464156 - Support for index compression in BRSPACE 7.20

[Thomas_Berger]

Hello,

I have two questions to the community:

1) who use the brspace tool to compress all indizes of a sap erp system?

2) when you use the brspace tool - which evaluation procedure you are using?

thank you for your help

Thomas

Note 1464156

[Former Member · Accepted solution]

Hi Thomas,

consider to reorg tables, activating indexes during reorg. In this way you'll perform two optimizations (reorg and index compression) in one step, without lock problems.

Index rebuild generate table locks, that may last for minutes/tables on huge tables.

I usually use ora_proc evaluation procedure.

Regards

Leo