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 -> Estimate I/O cost

Estimate I/O cost

From: Marco Poetke <poetke_at_dbs.informatik.uni-muenchen.de>
Date: Fri, 25 May 2001 17:32:42 +0200
Message-ID: <3B0E7B1A.2BDA6A16@dbs.informatik.uni-muenchen.de> 






Hi!



Is there a way to get the I/O cost estimated by the
built-in optimizer?



Unfortunately, the measure of 'COST' in the PLAN_TABLE
is undefined (according to the doc). The 'BYTES'
attribute seems to correspond to the output size, but
not the amounts of data touched during the query.



Thank you very much!!




Marco.
Received on Fri May 25 2001 - 10:32:42 CDT












Original text of this message













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