Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-12 : 01:24:36
|
Richard A. writes "Under what general circumstances are subqueries in the "IN" clause faster than doing inner joins? I've been told one case is where the subquery is proportially small to the main query in terms of number of records. Are there any ways to determine beforehand which queries could benefit from IN subqueries over INNER JOINs?
Thanks,
Richard" |
|
|
|
|
|
INNER JOINs vs IN(subqueries)