1 Reply Latest reply on Jul 24, 2020 10:46 AM by mpatzwahl

    Oracle XE 11g and 18c does not use Index Compression

    mpatzwahl

      Hi,

       

      i thought the standard index compression was always part of xe.

       

      What i did:

       

      SELECT bytes FROM dba_segments where segment_name='XXXX';

      => XYZ MB

      ANALYZE INDEX xxxx VALIDATE STRUCTURE;

      => Tells me 65% reduction when using 3 cols for compress, ok lets do it

       

      ALTER INDEX XXXX REBUILD COMPRESS 3;

      SELECT bytes FROM dba_segments where segment_name='XXXX';

      => XYZ MB (same size)

       

      Does anybody know why ?

      Thanks

      Marco