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 1:48 pm

    #1285897

    I also use SELECT NULL.

    Personally if something is faster and there's virtually no complexity difference, I use the faster version. Why waste where there is no need is my motto.

    -------------------------------------------------------------------------------------------------
    My SQL Server Blog