cancel
Showing results for 
Search instead for 
Did you mean: 

Impact of reverting ADVANCED_INDEX_COMPRESSION_OPTIONS parameter

SAPSupport
Employee
Employee
0 Kudos

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.
View Entire Topic
SAPSupport
Employee
Employee
0 Kudos

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