Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
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;
=> XYZ MB (same size)
Does anybody know why ?
i found the solution:
The index had a huge initial extent, and the rebuild does not lower this value !