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 |
|
baranozgul
Starting Member
20 Posts |
 Posted - 2005-04-18 : 03:02:56
|
| Do I need to avoid WHERE IN clauses to make sure a query uses indexes? |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-04-18 : 07:38:10
|
| Not necessarily, but if you have the "IN" values in another table, possibly a temporary table, you could just JOIN that to your main query table(s), and you might find that that was quicker.Kristen |
 |
|
|
|
|
|
WHERE IN clause and Indexes