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

Re: Why does explain plan show cost of 0

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 27 Jun 2002 17:45:29 +0100
Message-ID: <3d1b4129$0$8512$ed9e5944@reading.news.pipex.net>


no stats?

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"Steve" <smontgomerie_at_hotmail.com> wrote in message
news: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 Thu Jun 27 2002 - 11:45:29 CDT

Original text of this message

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