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