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”.

  • February 11, 2011 at 2:28 am

    #1285566

    Dave Ballantyne (2/10/2011)

    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

    thanks dave for your reply and sharing nice article