Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> delete from table

delete from table

From: Christian Cuske <cuske_at_rumms.uni-mannheim.de>
Date: Thu, 26 Oct 2000 23:22:39 +0200
Message-ID: <8ta75f$86s$1@trumpet.uni-mannheim.de>

Hello,

I have a problem when deleting from a table with about 100,000 rows and 20 columns.
Usually between 4 and 5 records are deleted at a time, the field in the where clause is a primary key. Sometimes, and it seems to happen more often every day, the statement takes more than a minute.
Any ideas?
Selecting and inserting works fine.

Thanks
Christian Received on Thu Oct 26 2000 - 16:22:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US