Re: Compressed tables

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Sat, 08 Oct 2005 15:38:52 +0200
Message-ID: <di8i4m$qd4$00$1@news.t-online.com>

AnySQL (d.c.b.a) schrieb:
> Do not use compressed table, but you can use compressed index, since
> index can be rebuilded.
>
> In oracle 9i, compress table is not so robust!
>

Not sure, what is meant under "robust".
Tables can every time be converted to compressed/uncompressed by simple alter table ... move compress/nocompress. There are some limitations bounded to , but altogether table compression is an excellent feature, if properly ( in suitable environment ) applied. Benefits are obvious - saving of storage, much faster fts, much faster calculation of aggregates. Combined with partitioning makes it even more flexible because different partitions can be compressed selectively.

Best regards

Maxim Received on Sat Oct 08 2005 - 08:38:52 CDT