On Mon, May 18, 2009 at 3:13 PM, Joshua Berry <yoberi(at)gmail(dot)com> wrote:
> Any hints/tips? Is our original solution okay, or is there something we can
> do to improve things?
It seems as if you don't really care about the results of the query-
just whether or not it returns any rows. In that case, why not
something like:
select (case when exists (select * from foo where...) then true else
false end) as result;
--
- David T. Wilson
david(dot)t(dot)wilson(at)gmail(dot)com