Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sql statement using full table scan ... HELP
Hi there,
What if to try:
delete from activities where activities.rowid in (select activities.rowid from activities, stars where activities.contact_entity_id = stars.entity_id);
Hope I got it right,
Mike
Received on Wed Dec 02 1998 - 11:16:58 CST