Re: cpu time and query column in tkprof output

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Fri, 04 Feb 2005 08:35:02 -0700
Message-ID: <42039626.7000209@centrexcc.com>

I have to admit that I didn't look closely at the sql. I went by the assumption that the purpose of the test was to find the faster of two semantically equivalent solutions. If that is not the case, then what is the point of the comparison. You have to go with the solution which gives the correct answer rather than the one that gives some answer faster.

jaromir nemec wrote:

> Hi,

>>If both do the same, shouldn't at least bytes sent be the same?

>
> They don't necessary do the same. Correlated EXISTS and a join return
> different results if the join key (in this case
> faxutil.t_kfs_tabstatuses.tabno , faxutil.t_kfs_tabstatuses.pool_status,
> faxutil.t_kfs_tabstatuses.job_status) is not unique.
>

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 04 2005 - 10:37:42 CST