Re: cost based optimization

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Tue, 31 Aug 1999 06:05:31 +0200
Message-ID: <936072370.28146.0.pluto.d4ee154e@news.demon.nl>

Rule based optimizer is still there, but not supported, NO development. It doesn't know about partitioned tables. So yes, I would expect a switch to CBO. Hth,

--
Sybrand Bakker, Oracle DBA

<hxn_at_yahoo.com> wrote in message news:7qfevu$oj0$1_at_nnrp1.deja.com...
> A question on Optimizer:
>
> I was told that on a partitioned table -
> even if you specify Optimizing=RULE in the init file,
> Oracle still switch to Cost based optimizing -
> Don't know if this is true.
>
> Henry
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Aug 30 1999 - 23:05:31 CDT