Re: Query Execution Time

From: DA Morgan <>
Date: Thu, 20 Nov 2008 12:18:13 -0800
Message-ID: <>

raja wrote:
> Hi,
> This mail is regarding the explain plan output, I have the following
> doubts, Please clarify them :
> 1.
> In the below explain plan, what does the rows column here mean.
> Should we have the exact number of rows in our query output as present
> here ?

The number of rows the optimizer expects to require to satisfy that part of the plan.

> 2. For good performance, do we have to check the plan or the execution
> time.


> 3. What is the Bytes column ?

See the answer to #1.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Thu Nov 20 2008 - 14:18:13 CST

Original text of this message