>>> Daniele Varrazzo <piro(at)develer(dot)com> wrote:
> select count(*) from foo
> where foo.account_id in (
> select id from accounts where system = 'abc');
> Total runtime: 13412.226 ms
Out of curiosity, how does it do with the logically equivalent?:
select count(*) from foo
where exists (select * from accounts
where accounts.id = foo.account_id
and accounts.system = 'abc');
-Kevin