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

Home -> Community -> Mailing Lists -> Oracle-L -> explain plan parameter meanings

explain plan parameter meanings

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Fri, 03 Jan 2003 01:54:03 -0800
Message-ID: <F001.005266D2.20030103015403@fatcity.com>


In the explain plan what is meant by "cost" , "card" and "byte" ? How may they be interpreted practically ? Any Docs , Links on the Same ?    

Execution Plan


   0 SELECT STATEMENT Optimizer=CHOOSE (Cost=6 Card=1 Bytes=76)    1 0 NESTED LOOPS (Cost=6 Card=1 Bytes=76)

   2    1     NESTED LOOPS (Cost=5 Card=1 Bytes=50)
   3    2       TABLE ACCESS (BY INDEX ROWID) OF 'GENERAL_ACCT_MAST_TA
          BLE' (Cost=3 Card=1 Bytes=17)
 
   4    3         INDEX (UNIQUE SCAN) OF 'IDX_GAM_FORACID' (UNIQUE)

(Cost=2 Card=1)
 

   5 2 TABLE ACCESS (BY INDEX ROWID) OF 'ASHT_DTD' (Cost=2 Card=5830 Bytes=192390)  

   6 5 INDEX (RANGE SCAN) OF 'IDX_ASHT_DTD_ACID' (NON-UNIQUE)
(Cost=1 Card=5830)
 

   7 1 TABLE ACCESS (BY INDEX ROWID) OF 'ASHT_TDTD' (Cost=1 Card=2105 Bytes=54730)  

   8 7 INDEX (UNIQUE SCAN) OF 'IDX_ASHT_TDTD' (UNIQUE)   Thanks  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: VIVEK_SHARMA
  INET: VIVEK_SHARMA_at_infosys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Jan 03 2003 - 03:54:03 CST

Original text of this message

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