Home Forums Article Discussions Article Discussions by Author Discuss content posted by Edward Polley Large table cleanup with minimal locks RE: Large table cleanup with minimal locks
app1dak
Newbie
Points: 6
More actions
March 5, 2012 at 11:20 pm
#1455115
Is the IN Clause in the WHERE predicate faster than using the WHERE EXISTS clause? I've heard that large IN Clauses tend to be slow performers. I work mostly with DB2 on iSeries though. Just starting using SQL Server for some projects.