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 17:43:13 +0200
Message-ID: <607D6181D9919041BE792D70EF2AEC48242BCA@LIMENS.sivsa.int>


Hi Hemant

The real count of rows returned by each step in the plan, is recorded there in the raw trace ("STAT #2 id=13 ===> cnt=8538 <=== .... ")

>When you say " Why the returned rows are so different ..."
>can you tell us the number of rows returned ? That isn't clear in
>the STAT output.

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

Original text of this message

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