Home Forums SQL Server 2005 T-SQL (SS2K5) EXISTS Subqueries: SELECT 1 vs. SELECT * (Database Weekly 11.02.2008) RE: EXISTS Subqueries: SELECT 1 vs. SELECT * (Database Weekly 11.02.2008)

  • June 13, 2014 at 4:24 am

    #1721396

    Hi All

    I have a question like if we use

    (SELECT top 1 1 from) instead of (SELECT 1 from) will it contribute in some sort of improvement.

    I am talking about EXISTS here.

    Thanks

    Satvir