Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Thumbs Up on Compression
You may find the following article useful:
http://www.oracle.com/technology/oramag/oracle/04-mar/o24tech_data.html
On Tue, 25 Jan 2005 21:29:41 +0100, Christian Antognini
<Christian.Antognini_at_trivadis.com> wrote:
> Hi Ian
>
> >The performace increase wad better than I expected. Results were very
> >similar for the handful of pv_ids I tried.
>
> The main problem of a compressed table (or partition) is the poor =
> support of DML statements. That said, if you can either reorganize it =
> when the data is mostly read-only or only do direct inserts, it's a =
> great feature!
>
> Just my 2 cents...
> Chris
> --
> http://www.freelists.org/webpage/oracle-l
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 25 2005 - 23:26:55 CST
![]() |
![]() |