Re: Index compression vs. table compression

Mark Bole <makbo_at_pacbell.net> wrote:

>The following terms appear: "data_segment_compression" for tables and
>tablespaces, plus "key_compression" for indexes -- but there is not an
>explanation why a tablespace attribute setting can cause table
>partitions (and, presumably, non-partitioned tables) to default to a
>given "compress" attribute, but not indexes.

In other words: What happens when an index is rebuild to a compressed tablespace? Don't know.

>The syntax as quoted from the OP: "ALTER INDEX xxx REBUILD
> >> COMPRESS y TABLESPACE DWH_16_IDX" is not documented anywhere, in
>other words the "compress y" clause does not appear to have any meaning
>(but the "compress [integer]" clause does, of course).

The "y" was meant to be an integer...

Bye
Rick Denoire Received on Tue Dec 28 2004 - 20:17:42 CST