Re: Why does explain plan show cost of 0

stats are genereated through dbms_stats

generating the plan with with...... set autotrace on explain ..same results when looking at plan through TOAD.

Oracle 8.1.6.0

seeing this behahavior alot , seems to be exclusive to partionined tables

tks

steve

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<1025461976.4258.0.nnrp-14.9e984b29_at_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 Tue Jul 09 2002 - 16:41:14 CDT