Re: Query Execution Time
Date: Thu, 20 Nov 2008 12:18:13 -0800
> This mail is regarding the explain plan output, I have the following
> doubts, Please clarify them :
> 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
> 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.orgReceived on Thu Nov 20 2008 - 14:18:13 CST