Uncompressed Index Size is Smaller than Compressed Index
Last updated on SEPTEMBER 16, 2016
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Information in this document applies to any platform.
After un-compressing an index, the size becomes smaller than when it was compressed.
The following testcase shows the issue:
A compressed index is uncompressed.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms