Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Cost=BLANK on query plan display
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