Kevin Grittner <Kgrittn(at)wicourts(dot)gov> wrote:
> Maybe before I get excited I should try it with a query which is
> actually logically equivalent.
Fixed version:
DELETE FROM foo
where type = 'o' and foo.b in (
select b from foo WHERE type = 'o'
except SELECT b FROM bar
except SELECT b FROM foo where type <> 'o');
The change didn't affect run time significantly; it still beats the
others.
-Kevin