Re: Convert SAP Oracle Database to IBM DB2 Database??
From: Mark Townsend <markbtownsend_at_sbcglobal.net>
Date: Fri, 08 Feb 2008 05:45:05 GMT
Message-ID: <47ABEC5D.8060609@sbcglobal.net>
> Well the nice thing about BLOGs is the ability to give feedback.
> You are a teacher, no? Teach!
>
> Cheers
> Serge
Date: Fri, 08 Feb 2008 05:45:05 GMT
Message-ID: <47ABEC5D.8060609@sbcglobal.net>
>> >> What I'm saying is that it is not just superficial ... from a >> technical point-of-view it is mostly incorrect. He needs to learn how >> to read the >> on-line docs.
> Well the nice thing about BLOGs is the ability to give feedback.
> You are a teacher, no? Teach!
>
> Cheers
> Serge
Eaton's blog is basically correct. However he mentions the negatives of the Oracle design, and does not mention the advantages. The greatest advantage of having the symbol table local to the page is that you do not have to do another I/O to read the symbol table - the single block I/O gets the compressed data and the symbols required to uncompress it. Our testing in large scale environments shows that to me more beneficial than the IBM design. There are also additional benefits accrued from not having to expand a single symbol table when the data values grow, etc.
So it's horses for courses. We just think our horses are better. YMMV, and as always, test well. Received on Thu Feb 07 2008 - 23:45:05 CST