Re: Breaking up a query

On Thu, Aug 10, 2006 at 06:53:33PM -0400, Saad Anis wrote:
> Hi Guys,
> 
> A fellow at work has written the SQL below to retrieve some data from
> multiple tables. Obviously it is inefficient and unnecessarily complex, and

Why is that obvious?  Why do you think that joining in your
application is going to give better performance than joining in the
database?  This is what RDBMS _do_, for heaven's sake.

(I agree that your plan shows it's taking a long time.  But that's a
different problem.  We don't actually know what you want from your
query.)

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
I remember when computers were frustrating because they *did* exactly what 
you told them to.  That actually seems sort of quaint now.    --J.D. Baldwin