Re: Index compression on Oracle 9.2

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Fri, 03 Feb 2006 08:14:17 -0500
Message-Id: <1138972457l.4469l.1l@medo.noip.com>

On 02/03/2006 07:18:51 AM, Christian Antognini wrote:
> Jurijs
>
> >BTW: If some body have got results of that kind of testing, please do
> >not hesitate to share them with the list ;))))
>
> A coworker did similar tests. You find the results, in German, here http://www.trivadis.com/Images/table_compression_tcm16-7201.pdf. The paper, unfortunately only partially, has been translated in English as well, see http://www.trivadis.com/Images/table_compression_0404en_tcm17-12678.pdf.

I must say that the paper is excellent, especially the finding that one must use direct insert as the normal insert will practically cancel any compression. Also, space allocation after update of 10% and 90% rows is shocking. Also, I was suprised how little was gained on hash joins. Uebersetzung auf Englisch ist nicht notwendig.

-- 
Mladen Gogala
http://www.mgogala.com

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 03 2006 - 07:14:17 CST