Re: Tom Kyte's book obsolescence
Date: Sat, 2 Feb 2008 07:19:34 -0800 (PST)
On 2 Febr., 16:22, Mladen Gogala <mgog..._at_yahoo.com> wrote:
> Unfortunately, it seems
> that self-join is faster for the queries that can be written in both ways.
> My post was not meant as dumping the analytic functions altogether, my
> post was just observing the difference between versions.
Oh yea, here I completely agree.
Actually if we look at the example in Tom's book the difference of elapsed columns between these two versions is not big: for analytic version it is 26.90, for subquery 29.43.
http://www.gplivna.eu Received on Sat Feb 02 2008 - 09:19:34 CST