Impact of reverting ADVANCED_INDEX_COMPRESSION_OPTIONS parameter

[SAPSupport]

Hi Sap,

We are reverting ADVANCED_INDEX_COMPRESSION_OPTIONS parameter and rebuilding the affected indexes in our SAP environment. 

Please let us know if 

1. Any potential risks or side effects associated with this change.
2. Impact on data consistency.
3. Any recommended best practice or steps to mitigate risks and ensure a smooth transition.

Thanks,

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Dear Customer,

The only side effect of the change is that the index size will be bigger without the compression.

On the data inconsistency there won't be any impact.

For more information you can check below note:

2138262 - Oracle Database 12c Advanced Compression for SAP Systems 

Best regards,
SAP Product Support