Re: Index compression on Oracle 9.2

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

Other related posts: