Skip to Main Content
Forums

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

mpatzwahlJul 22 2020 — edited Jul 24 2020

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
This post has been answered by mpatzwahl on Jul 24 2020
Jump to Answer

Comments

Can you please have a look at the VS Code Windowing options to see if any of them do what you want?
In the VS Code menu, select View->Editor Layout

User_ZZQ0F

Everytime I run query I use shortcut Ctrl+Alt+Right to split pane.
Would be nice to do make it automatically.

1 - 2

Post Details

Added on Jul 22 2020
1 comment
614 views