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>
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