Re: Tom Kyte's book obsolescence

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Sat, 2 Feb 2008 07:19:34 -0800 (PST)
Message-ID: <039265a7-4dfe-40de-84b0-899f9ee1236f@e10g2000prf.googlegroups.com>


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.

Gints Plivna
http://www.gplivna.eu Received on Sat Feb 02 2008 - 09:19:34 CST

Original text of this message