Re: Query Execution Time

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 20 Nov 2008 12:18:13 -0800
Message-ID: <1227212269.972147@bubbleator.drizzle.com>


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.

Both.

> 3. What is the Bytes column ?

See the answer to #1.

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

Original text of this message