Re: [GENERAL] Please help to speed up UPDATE statement

2005-04-12 Thread Bob Henkel
On Apr 12, 2005 9:40 AM, Andrus <[EMAIL PROTECTED]> wrote: The following statement runs VERY slowly on large tables.Any idea how to speed it up ?UPDATE rid SET dokumnr=NULL WHERE  dokumnr NOT IN (SELECT dokumnr FROM dok);Tables:CREATE TABLE dok ( dokumnr INTEGER,   CONSTRAINT dok_pkey PRIM

[GENERAL] Please help to speed up UPDATE statement

2005-04-12 Thread Andrus
The following statement runs VERY slowly on large tables. Any idea how to speed it up ? UPDATE rid SET dokumnr=NULL WHERE dokumnr NOT IN (SELECT dokumnr FROM dok); Tables: CREATE TABLE dok ( dokumnr INTEGER, CONSTRAINT dok_pkey PRIMARY KEY (dokumnr) ); CREATE TABLE rid ( dokumnr