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
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