Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by David Poole Time Bomb Coding RE: Time Bomb Coding
CraigIW
SSCrazy
Points: 2301
More actions
February 10, 2010 at 1:56 am
#1116622
nicholasw (2/10/2010)Instead of:IF EXISTS(SELECT 1 FROM ......WHERE....)Would the following be quicker still?IF EXISTS(SELECT TOP 1 1 FROM ......WHERE....)
nicholasw (2/10/2010)
IF EXISTS(SELECT 1 FROM ......WHERE....)
Would the following be quicker still?
IF EXISTS(SELECT TOP 1 1 FROM ......WHERE....)
No, as the "top 1" is only done after the "select 1 from".