Re: delete from table

From: John Alexander <jalexander_at_summitsoftwaredesign.com>
Date: Fri, 27 Oct 2000 01:11:37 GMT
Message-ID: <dD4K5.2038$68.196188@typhoon.tampabay.rr.com>

Does the explain plan say it is using the index? If so, (you probably have already covered this) the first place I would look at would be at any triggers that may be firing on delete.

Christian Cuske <cuske_at_rumms.uni-mannheim.de> wrote in message news:8ta75f$86s$1_at_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 - 20:11:37 CDT