Re: query performance -- revised!

Doug wrote:

> Apologies for the last post (query performance) -- especially because
> I made the mistake before. I have corrected my syntax and there is
> still a threshold (43 ORs) at which it switches from using an index to
> using a table scan on the Address table. I am suspicious of its
> decision because our previous db server (OpenBase) ran this query
> considerably faster, even with hundreds of ORs. Query and query plan:
>
> <snipped>

Version and edition?
Optimizer mode?
Current statistics? Generated how?

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