Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to find the Overall cost of a query?

Re: How to find the Overall cost of a query?

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Mon, 19 Dec 2005 17:36:27 GMT
Message-Id: <pan.2005.12.19.17.36.27.101723@sbcglobal.net>


On Mon, 19 Dec 2005 09:32:03 -0800, Jimbo1 wrote:

> The gist of it is though, cost should not be used as a tuning stat. It
> is almost like a random number.

Cost is expressed in single block I/O requests that need to be fulfilled in order to execute the query. Problem with the cost is that it is only an estimate and the estimate can be grossly incorrect.

-- 
http://www.mgogala.com
Received on Mon Dec 19 2005 - 11:36:27 CST

Original text of this message

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