Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: All bitmap indexes not being used in a query where they should be
I was trying that line of attack also. Unfortunately, I've imported
the the tables into a 9.2.0.4 instance and it looks like it's
exhibiting the same behavior.
Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1074727627.565416_at_yasure>...
> Steve B wrote:
>
> > We're running Oracle 8.1.6.1.0.
>
> That's all you needed to say. The optimizer in 8.1.6 was at its very
> worst. I'd strongly suggest that you upgrade to 8.1.7.4 or preferably
> 9.2.0.4 before investing one hour tuning anything you have.
Received on Fri Jan 23 2004 - 08:17:36 CST