Re: Upgrade to 7.3 - Concerns

Jeff Masteller wrote:
>
> 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

SQLNET V1 goes away... Received on Mon Apr 21 1997 - 00:00:00 CDT