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 -> Re: sql statement using full table scan ... HELP

Re: sql statement using full table scan ... HELP

From: Michael Komlev <mike_komlev_at_avionics.bfg.com>
Date: Wed, 02 Dec 1998 12:16:58 -0500
Message-ID: <3665760A.E7CEA3C8@avionics.bfg.com>


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

Original text of this message

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