Re: Why does explain plan show cost of 0

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 10 Jul 2002 08:50:54 +0100
Message-ID: <1026287387.13426.3.nnrp-10.9e984b29@news.demon.co.uk>

Unsupported version of Oracle - could be a bug that's been fixed in newer versions.

Not a lot you can do about it.

Check that you are getting stats on

dba_tables
and

dba_tab_partitions
though.

--
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.0207091341.731c5abb_at_posting.google.com>...


>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

Received on Wed Jul 10 2002 - 02:50:54 CDT