Re: optimizer_ ???

Robyn,

that's how I remember it too.
I don't deny that some people have had success lowering oica or raising 
oic - and for individual sql I have used them too ( I remember one case 
where I deliberately set oica to 1 so that differences in index costs 
would disappear and the index be determined by the tie-breaking rule 
which was the index I needed) but I really don't like the idea of 
setting them system-wide.

Robyn wrote:
> I attended Wolfgang's presentation on oica and oic at hotsos, and
> towards the end of the presentation, he said using system statistics
> would provide better results than adjusting oica and oic.  This was

> 
> Of course, if I've misremembered the presentation, someone please let me kn=
> ow.
> 

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l

Other related posts: