Steinar,
> I've tried some further tweaking, but I'm still unable to force it into
> doing a hash join -- any ideas how I can find out why it chooses a merge
> join?
I'm sorry, I can't really give your issue the attention it deserves. At this
point, I'd have to get a copy of your database, and play around with
alternate query structures; and I don't have time. Sorry!
--
Josh Berkus
Aglio Database Solutions
San Francisco