Re: [SQL] update and IN vs. EXISTS

2003-02-03 Thread Tambet Matiisen
> -Original Message- > From: pginfo [mailto:[EMAIL PROTECTED]] > Sent: Saturday, February 01, 2003 3:50 PM > To: Bruno Wolff III > Cc: [EMAIL PROTECTED] > Subject: Re: [SQL] update and IN vs. EXISTS > > > > > Bruno Wolff III wrote: > > &

Re: [SQL] update and IN vs. EXISTS

2003-02-01 Thread pginfo
Bruno Wolff III wrote: > 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 fieldF

Re: [SQL] update and IN vs. EXISTS

2003-02-01 Thread Bruno Wolff III
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 = T