Re: Oracle 10g vs. 9.2

"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...?

It will vary by statement. In fact one person with whom I was having a discussion recently found that the same code executed slower on 10g than 9.2 The thing to do is to benchmark your code. However

>
> I can't see how 10g will be faster than 9i. Unless there has been
> significant improvement of the optimizer in this release.

Well the CBO is improved (though perhaps not as much as 9i over 8i). PL/SQL is significantly faster (as a generalization) as well. Perhaps notably some repeated single row fetches get transparently executed as array fetches in 10.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com