Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: performance question

RE: performance question

From: Alvaro Jose Fernandez <alvaro.fernandez_at_sivsa.com>
Date: Mon, 10 Sep 2007 16:15:13 +0200
Message-ID: <607D6181D9919041BE792D70EF2AEC48242BB9@LIMENS.sivsa.int>


Joan,

it seems the excerpt you posted is incomplete (I cannot understand that the last op is the hash join with id=13 on both plans)

please, ┐would you mind to post a tkprof-processed plan of both (without running the "explain= " param of tkprof), just to compare why the diff in rowcounts?

QA
.
.

STAT #2 id=13 cnt=8538 pid=2 pos=2 obj=0 op='HASH JOIN (cr=217257 pr=23078 pw=4941 time=41906027 us)'

TRN
.
.
.
.

STAT #1 id=13 cnt=0 pid=2 pos=2 obj=0 op='HASH JOIN (cr=0 pr=0 pw=0 time=0 us)'

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 10 2007 - 09:15:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US