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: Cost=BLANK on query plan display

Re: Cost=BLANK on query plan display

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: Fri, 01 May 1998 21:53:37 GMT
Message-ID: <354a445d.4876458@www.sigov.si>


On Fri, 01 May 1998 15:51:49 +0100, Jason Selby <jselby_at_cams.co.uk> wrote:

>....[SNIP]....
>Why is 'Cost=' always a blank figure is there another way of getting the
>overall cost of a query

It's because your queries are executed using rule based optimizer, where cost is irrelevant. POSITION column in a PLAN_TABLE is allways NULL when rule based optimizer is used. The reason for CBO not being used can be in your initialisation parameter OPTIMIZER_MODE or you statistics for the tables involved have not been collected.

>TIA
>
>Jason

Regards,


Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================
The above opinions are mine and do not represent any official standpoints of my employer Received on Fri May 01 1998 - 16:53:37 CDT

Original text of this message

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