Home Forums Article Discussions Article Discussions by Author Discuss content posted by Dave62 What's the best way to count? RE: What's the best way to count?

  • December 26, 2012 at 11:48 pm

    #1571753

    Is there any performance difference in the below given three queries.

    Note: Col1 is NOT NULL column

    SELECT COUNT(*) FROM Sales.SalesOrderDetail;

    SELECT COUNT(Col1) FROM Sales.SalesOrderDetail;

    SELECT COUNT(0) FROM Sales.SalesOrderDetail;