Re: Tom Kyte's book obsolescence

From: Noons <>
Date: Sat, 2 Feb 2008 03:33:47 -0800 (PST)
Message-ID: <>

On Feb 2, 2:02 am, Mladen Gogala <> wrote:

> This discovery is loaded with implications:
> 1) Oracle does I/O in versions 10g and 11g in the different way then it
> used to in versions 9i and below. I am not sure what exactly is the
> difference, but there is a difference.
> 2) Analytic functions are now just a neat trick, no longer a performance
> improvement. The cost of the window buffer sort is relatively high
> compared to the cost of simple join.
> 3) Some information in "Effective Oracle by Design" is obsolete. How much,
> exactly?

Good catch, Mladen.
Thanks for that. Received on Sat Feb 02 2008 - 05:33:47 CST

Original text of this message