Re: Query Execution Time

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