Re: optimizer_ ???
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: robyn.sands@xxxxxxxxx
- Date: Fri, 22 Apr 2005 14:21:45 -0600
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
