How to optimize SQL code with IN (....) - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

How to optimize SQL code with IN (....)

Message

From

08/11/2005 04:45:13

Ric Parodi
ESolar, Inc
Monrovia, California, United States

To

07/11/2005 05:40:21

Virusim Sim
Singapore, Singapore

General information

Forum:

Microsoft SQL Server

Category:

Other

Title:

Re: How to optimize SQL code with IN (....)

Miscellaneous

Thread ID:

01065924

Message ID:

01066337

Views:

13

I think Steven's answer wins on this one... Using EXISTS has worked quite well for large amounts of data.

Ricardo A. Parodi
eSolar, Inc.

Click here to load this message in the networking platform