Re: [PERFORM] Efficiency of EXISTS?

2012-07-23 Thread Kenneth Tilton
On Mon, Jul 23, 2012 at 2:52 PM, Merlin Moncure wrote: > On Mon, Jul 23, 2012 at 4:12 PM, Kenneth Tilton wrote: > > My mental model of the EXISTS clause must be off. This snippet appears at > > the end of a series of WITH clauses I suspect are irrelevant: > > > >&

[PERFORM] Efficiency of EXISTS?

2012-07-23 Thread Kenneth Tilton
My mental model of the EXISTS clause must be off. This snippet appears at the end of a series of WITH clauses I suspect are irrelevant: with etc etc ... , cids as > (select distinct c.id from ddr2 c > join claim_entries ce on ce.claim_id = c.id > where (c.assigned_ddr = 879 > or exists (select 1