Home Forums Article Discussions Article Discussions by Author Discuss content posted by Igor Micev The COUNT Function in T-SQL RE: The COUNT Function in T-SQL

  • July 12, 2016 at 5:40 am

    #1889569

    Karl Klingler (7/12/2016)

    Hello Igor,

    in the article you pose the question "Which Is Faster: COUNT(*) or COUNT(1)?", but actually you answer with "COUNT(*) versus COUNT(ID)" (which is not the same as count(1))

    Is there something missing in the article or did you just get the same results for COUNT(1) and COUNT(ID)?

    regards

    karl

    Hello Karl,

    Your remark is in place. Thanks.

    Actually it's the same, because ID is the PK of the demo table. COUNT(1) and COUNT(ID) perform the same here. I'll consider this to correct in the text.

    Igor Micev,My blog: www.igormicev.com