On Wed, Apr 30, 2003 at 10:12:35 -0600,
Chad Thompson <chad(at)weblinkservices(dot)com> wrote:
> Hey guys/gals
> I have a update that is slow and I cant get my head around a way to make it
> faster.
>
> update table set id = '555'
> where id in (select id from different_table)
>
> pretty simple... i tried using exists as well.. but it still seems to be
> very slow.
This will probably run faster in 7.4 as "in" has been improved.
If id is a unique column in different table, then you might try the following:
update table set id = '555' from different_table where table.id =
different_table.id