Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: All bitmap indexes not being used in a query where they should be

Re: All bitmap indexes not being used in a query where they should be

From: Steve B <BigBoote66_at_hotmail.com>
Date: 23 Jan 2004 06:17:36 -0800
Message-ID: <67bcf80a.0401230617.712ee3bf@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US