2008/1/15 Thomas Markus <[EMAIL PROTECTED]>:
> Hi,
>
> How can I speed up updates?
> i try an
>   update tablename set datecol=null
> ~ 2.3 mio rows

Got any foreign keys against that table?  If so, they need to be
indexed on the other end.

What's the schema of that table and any related tables?

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to