Hello all,
I created a query that contains two subqueries and joins and would like some
feedback on whether:
1) this approach is logical; and,
2) if this is an optimal approach (performance wise) to return the records
I seek.
Essentially, I am attempting to perform a 'lookup' on a value in ano
erformance differences were
negligable. Any further thoughts or should I just stick with what I have
and move on?
Thanks in advance.
Cheers,
Jim
From: Richard Huxton
To: T- Bone <[EMAIL PROTECTED]>
CC: pgsql-sql@postgresql.org
Subject: Re: [SQL] Comments on subquery performance
Date: Thu, 17 F
(second attempt in two days to post this message...I appologise if for some
reason a duplicate appears)
Hello all,
I created a query that contains two subqueries and joins and would like some
feedback on whether:
1) this approach is logical; and,
2) if this is an optimal approach (performance
