[PERFORM] sub-select makes query take too long - unusable

2009-11-21 Thread Mark Dueck
Hi all, The query below is fairly fast if the commented sub-select is commented, but once I included that column, it takes over 10 minutes to return results. Can someone shed some light on it? I was able to redo the query using left joins instead, and it only marginally increased result time. T

[PERFORM] sub-select makes query take too long - unusable

2009-11-21 Thread Mark Dueck
Hi all, (Sorry, I know this is a repeat, but if you're using message threads, the previous one was a reply to an OLD subject.) The query below is fairly fast if the commented sub-select is commented, but once I included that column, it takes over 10 minutes to return results. Can someone shed s