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

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.

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