Re: Table compression experience?

From: Amar Kumar Padhi <amar.padhi_at_gmail.com>
Date: Fri, 25 Jul 2008 15:49:41 +0400
Message-ID: <4889BDD5.5040302@gmail.com>

In 9i, table compression prevent us from adding/modifying columns later. We opted to use compression (in 9i and 10g) for composite indexes only, this saves us lot of space with no impact on performance.

Thanks!
amar

Ben Wittmeier wrote:
>
> Does anyone have any negative experiences in using table compression?
> The following link is what we have on it:
> _http://www.oracle.com/technology/products/bi/db/10g/pdf/twp_data_compression_10gr2_0505.pdf_
>
> Any of you guys have any warnings on its use?
> Thanks,
> Ben
>
>
>
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager. This message contains confidential information and
> is intended only for the individual named. If you are not the named
> addressee you should not disseminate, distribute or copy this e-mail.

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jul 25 2008 - 06:49:41 CDT

Original text of this message