SAP Knowledge Base Article - Preview

3717155 - Oracle database option _ADVANCED_INDEX_COMPRESSION_OPTIONS

Symptom

When this option is set, all newly created indexes will be compressed by default.

_ADVANCED_INDEX_COMPRESSION_OPTIONS = 16

However, the index before setting this option is uncompressed.
Note: This option requires "Oracle Advanced Compression" license.


Read more...

Environment

  • Oracle database 12.2.0.1
  • Oracle database 18c
  • Oracle database 19c
  • SAP Release independent
  • Operating System independent

Product

SAP Solution Manager all versions

Keywords

_advanced_index_compression_options16, sap solution manager, index compression, compress indexes, uncompressed indexes, rebuild indexes, database parameter, sap database, advanced index compression, sap solution manager indexes, index decompression, sap index management, database compression options, sap index rebuild, sap database optimization, sap index settings , KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.