Home Forums SQL Server 2005 T-SQL (SS2K5) IF Exists and a clause questions RE: IF Exists and a clause questions
Christian Buettner-167247
SSChampion
Points: 13729
More actions
January 23, 2008 at 12:28 pm
#771020
Hello Andras,
could you please provide an example where TOP 1 speeds up the query?
I was always under the assumption that SQL Server would automatically TOP the query when EXISTS is used.
Thanks!
Best Regards,
Chris Büttner