Re: Why does explain plan show cost of 0

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 30 Jun 2002 19:33:41 +0100
Message-ID: <1025461976.4258.0.nnrp-14.9e984b29@news.demon.co.uk>

Unusual.
Most methods for reporting the execution plan show integer values for cost and cardinality.

Which version of Oracle.
Which method for generating the plan ?

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminars
        UK            July / Sept
        Australia      July / August
        Malaysia        September
        USA (MI)        November
http://www.jlcomp.demon.co.uk/seminar.html

Steve wrote in message <156709aa.0206270824.4a72cad9_at_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 Sun Jun 30 2002 - 13:33:41 CDT