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