Re: Oracle 10g vs. 9.2

From: Dave <x_at_x.com>
Date: Mon, 08 Nov 2004 18:52:02 GMT
Message-ID: <mfPjd.9950$up1.4317@text.news.blueyonder.co.uk>

"Matt" <mccmx_at_hotmail.com> wrote in message news:cfee5bcf.0411080353.2c9b9450_at_posting.google.com...
>> 4. Faster performance on identical hardware
>
> Can you quantify this statement...?
>
> I can't see how 10g will be faster than 9i. Unless there has been
> significant improvement of the optimizer in this release.
>
> The only thing I can think of is that Subquery Unnesting is now costed
> in this version (which is a big argument for going for 10g over 9i).
>
> Matt

its the pl/sql engine - it justs runs faster, much more efficient at running you code.

There is a demonstration on askTom if you wanna check it out Received on Mon Nov 08 2004 - 12:52:02 CST