On Sat, Feb 01, 2003 at 12:40:00 +0100, pginfo <[EMAIL PROTECTED]> wrote: > > If I try to execute: > update Table1 set fieldForUpdate = 1 where ID IN (select T2.ID from > Table2); > it is running very slow.
You might try: update Table1 set fieldForUpdate = 1 from Table2 where Table1.id = Table2.id; This uses a nonstandard postgres extension and may not be portable, if that is a concern. INs are being speeded up in 7.4, so the original form might work a lot better in the next release. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
