Message-Id: <10572.113198@fatcity.com> From: Andreas Jung Date: Fri, 28 Jul 2000 09:21:35 +0200 Subject: Why does a simple delete takes 12 hours and longer ? Yesterday evening I started the following delete: delete from ojs_main_multiple where docnum not in (select docnum from ojs_main); ojs_main contains about 250.000 rows and ojs_main_multiple about 300.000 rows. docnum is a unique primary key of ojs_main. This morning after about 12 hours the delete was still running. Any idea why this happens ? Should I believe in "In Oracle we trust "? (our env.: Oracle 8i EE/Solaris on a Sun E450 with 4 CPUs) Andreas