Re: Tom Kyte's book obsolescence

From: Gints Plivna <>
Date: Sat, 2 Feb 2008 07:19:34 -0800 (PST)
Message-ID: <>

On 2 Febr., 16:22, Mladen Gogala <> 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.

Gints Plivna Received on Sat Feb 02 2008 - 09:19:34 CST

Original text of this message