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

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 23 Jan 2004 08:44:39 -0800
Message-ID: <40114F77.2030206@x.washington.edu>

Steve B wrote:

> 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.

Following import did you run DBMS_STATS to populate statistics for the optimizer?

Are you making this observation based on the fact that it is "slow" or have you actually run DBMS_XPLAN?

I don't have access to this thread's history. Have you posted the plan and the SQL?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Fri Jan 23 2004 - 10:44:39 CST