Manfred, > Sorry, I have no answer to your question, but may I ask whether you > really want to get presumably 106 output rows for each event with > status 1? > > Or did you mean > WHERE (events.status = 1 OR events.status = 11) AND ...
Thanks! I spent so much time tinkering around with the exists clauses, I completely missed that. Hopefully I'll get this client to upgrade to 7.4 so that the explains will be more readable .... -- Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
