I suspect this can be simplified. Thought people might find it amusing.
Andre Guirard | 10 November 2011 08:09:35 AM ET | | Comments (3)
1)
All I can say is .. WOW
But size alone is not a measure of a bad query. I once fixed a huge performance problem by changing a relatively small query to a larger one with a couple of UNION statements. Mine still easily fit on a single page, even if double space though.
But. WOW
2)
But it’s SQL, what do you expect?
I've seen a very rational SQL query that was about that long. It was actually a series of separate queries joined together. The query took about 4 hour to run against a 1/2 million row data set and generated a massive csv output file. Man I hated that thing...