Home Forums SQL Server 2008 SQL Server 2008 - General “SELECT 1″ rather than a “SELECT *” when using an EXISTS or a NOT EXISTS clause”. RE: “SELECT 1? rather than a “SELECT *” when using an EXISTS or a NOT EXISTS clause”.
Dave Ballantyne
SSC-Dedicated
Points: 33566
More actions
February 10, 2011 at 6:29 am
#1285132
There are the same , count(1) get converted to count(*) by the optimizer / parser.
See this post on my blog
http://sqlblogcasts.com/blogs/sqlandthelike/archive/2010/07/27/count-or-count-1.aspx