Re: Optimizer Instability on 10.2.0.2

Jack wrote:
> RBO is rock stable, and needs zero admin :)
> -> RBO is still better than CBO
> (If no need for some new features)
>
> want RBO back.

Especially when working with global temporary, compressed, external, index organized, partitioned, subpartitioned, and XML tables?

Especially when working with bitmap, bitmap join, compressed, descending, function based, and reverse indexes?

Especially when working with sorted hash clusters?

The RBO is dead for everyone not still working in Oracle < 8.1.6 or who restricts their work with Oracle to 8.0 features. It is time for this myth to be put out of its misery.

The RBO was good in its prime. It was deprecated for a reason. RIP.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org