2008/1/15 Thomas Markus <t.markus@xxxxxxxxxxxxx>: > 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 majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly