Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Upgrade to 7.3 - Concerns
Oracle made changes to it's cost based optimizer. It seems to think that full table scans are cheaper than index use. Our average reads per day jumped from 60 million to 150 million. This forced us to change from cost based as default to rule based. We then had to re-tune the queries that ran slowly back to cost
Greg Poirier wrote:
>
> I'm forced to do a rush upgrade to 7.3 from 7.0.16. If anyone knows of
> problems please forward to me.
>
> Thanks
>
> Greg Poirier
Received on Fri Apr 18 1997 - 00:00:00 CDT