Re: Index compression on Oracle 9.2
- From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
- To: Christian.Antognini@xxxxxxxxxxxx
- Date: Fri, 03 Feb 2006 08:14:17 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
