One of the notes in the 'New Features' pdf
points out that Oracle 9 has enhanced the
costing algorithm to include costs for
memory and CPU - perhaps this is the
basis for your extra 5%
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Practical Oracle 8i: Building Efficient Databases
Publishers: Addison-Wesley
Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
Mike Doherty wrote in message
<8b565c44.0106121813.39cbf22d_at_posting.google.com>...
>Had no problem with the install and had no problem with the upgrade.
>But to my suprise when i compared execution plans from 8.1.6 to the
>exact database on 9 the 9 db had 5% greater cost for identical
>queries. Again this is keeping the exact init params for the two
>systems.
>
>
Received on Tue Jun 12 2001 - 16:06:53 CDT
