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 -> Why does explain plan show cost of 0

Why does explain plan show cost of 0

From: Steve <smontgomerie_at_hotmail.com>
Date: 27 Jun 2002 09:24:23 -0700
Message-ID: <156709aa.0206270824.4a72cad9@posting.google.com>


I am seeing the following in an explain plan..what gives?

(Cost=.00000000000000 Card=.00000000000000)

It runs ok, just curious

full plan follows.....

tks

steve

SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1 Bytes=193)   NESTED LOOPS (Cost=2 Card=1 Bytes=193)     PARTITION RANGE (ITERATOR)
      TABLE ACCESS (BY LOCAL INDEX ROWID) OF PS_PROJ_RESOURCE
(Cost=.00000000000000 Card=.00000000000000 Bytes=.00000000000000)

        INDEX (RANGE SCAN) OF PSAPROJ_RESOURCE (NON-UNIQUE)
(Cost=.00000000000000 Card=.00000000000000)

    INLIST ITERATOR
      TABLE ACCESS (BY INDEX ROWID) OF PS_PROJ_ACTIVITY (Cost=1 Card=19078 Bytes=305248)

        INDEX (UNIQUE SCAN) OF PS_PROJ_ACTIVITY (UNIQUE) (Cost=1 Card=19078) Received on Thu Jun 27 2002 - 11:24:23 CDT

Original text of this message

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