> -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:
>
> &
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
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
Hi,
I have 2 tables Table1 and Table2.
The PK for Table1 is declared as name.
Table 2 have only 1 field and it is also name ( it is indexed).
I will to update all Table1.filedForUpdate for all rows that exists in
Table2.
In Table1 I have ~ 120 000 rows and in Table2 I have ~ 100 000.
If I execu
