Re: Tom Kyte's book obsolescence
Date: Sat, 2 Feb 2008 03:33:47 -0800 (PST)
On Feb 2, 2:02 am, Mladen Gogala <mgog..._at_yahoo.com> 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,
Good catch, Mladen.
Thanks for that. Received on Sat Feb 02 2008 - 05:33:47 CST