| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> delete statement taking forever
Hello, I hope someone can help me with a simple delete statement. Here
is the statement and the qplan. The appropriate fields are indexed.
Will it help to analyze the table with compute statistics? The
activities table has about 700k records and the mds_removed_id has
60k. Any way to optimize this statement? Also, I am finding that
there is a lot of disk swaps on the server when running this.
Thanks for your help,
Dave
explain plan
set statement_id = 'del_mds' for
delete from activities where contact_entity_id in
(select entity_id from mds_removed_id);
Q_PLAN
 |
 |