Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Which is quicker - INTERSECT or just subquery?

Status
Not open for further replies.

ASmee

IS-IT--Management
Jul 9, 2002
46
US
Which of these two would be the most efficient, and how do I ascertain this info:

delete from riskvarhistory where histjobid in (select histjobid from riskvarhistory INTERSECT select id from histvarjob@my_prim);

or

DELETE FROM RiskVarHistory WHERE histjobid in (select ID FROM histvarjob@my_prim);

Where @my_prim is a public database link.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top