Re: RBO to CBO

Oradba Linux wrote:

> Any major/minor issues to watch out for during the conversion especially
> with regards to sql written specifically to RBO

Strip out hints and retune each statement as required.

Pay special attention to the init parameters: optimizer_index_caching and optimizer_index_cost_adj

Tuning them can make a big difference.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)