Message
From
29/01/2017 10:57:36
Michel Fournier
Level Extreme Inc.
Petit-Rocher
,
New Brunswick
,
Canada
To
29/01/2017 10:55:51
Christian Isberner
Hannover
,
Germany
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re:
WHERE IN syntax for Exist/Not Exist
Environment versions
SQL Server:
SQL Server 2014
OS:
Windows 8.1
Network:
Windows Server 2012
Miscellaneous
Thread ID:
01647092
Message ID:
01647114
Views:
32
>What I learned is that IN with a subquery is always very poor performance and should never be done. Always use Exists instead.
>
>
http://stackoverflow.com/questions/2065329/sql-server-in-vs-exists-performance
Thanks
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the
Level Extreme Platform
Subscribe to the site at
https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits
https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Reply
Map
View the map of this thread
View the map of this thread starting from this message only
View
View all messages of this thread
View all messages of this thread starting from this message only