Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: delete from table
Yes, the optimizer uses the index(B-Tree).
There is no trigger on that table, but the PK is referenced by another
table as foreign key.
But the records from that table are deleted first.
"John Alexander" <jalexander_at_summitsoftwaredesign.com> schrieb im
Newsbeitrag news:dD4K5.2038$68.196188_at_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 Fri Oct 27 2000 - 03:04:24 CDT