Re: Select multiple rows from DUAL ?

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 10 Jan 2005 08:26:14 -0800
Message-ID: <41e2ab7a$1_3@127.0.0.1>

Noons wrote:

> DA Morgan wrote:
>
>

>>Well EXPLAIN PLAN certainly doesn't like it:

>
>
> Funny how 10.1 is so different from 9ir2...
> I wonder how much we can rely on the explain plan "cost"
> to mean anything, after all it's just a convention rather
> than an absolute number.
>
> The stats on the other hand tell us exactly what
> is going on re consistent gets vs physical gets.
> Or so they should, but that's not 100% certain either!

What I've heard is that the biggest difference between the 9i CBO and the 10g CBO is that in 10g the optimizer takes into account CPU. That may well be true but doesn't seem to explain the result.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---

Received on Mon Jan 10 2005 - 10:26:14 CST