Craig Farrell (11/22/2010)

---

Are the result sets large-ish (say 10k rows each or more?) independently? Are you doing more with the UNION ALL than you did with either of the...

I can't see the execution plan since it never finishes. That said, I will try your suggestion...

Thanks for the feedback.

I am already doing #1. The main problem with this is that it becomes a pain to track the cross referencing between the parent in the...