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@xxxxxxxxxxxx> 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 > -- > //www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l