Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Thumbs Up on Compression

RE: Thumbs Up on Compression

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Tue, 25 Jan 2005 21:29:41 +0100
Message-ID: <2CF83791A616BB4DA203FFD13007824A01E6B2FA@MSXVS02.trivadis.com>


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
Received on Tue Jan 25 2005 - 15:29:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US