Matt wrote:
>>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
Oracle performed a lot of optimization including, obviously, the
optimizer. But beyond that the code is tighter and some methodologies
improved.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Nov 08 2004 - 21:14:21 CST
