14 Kicks

SQL Server - Count(*) or Count(1) ? - Which is better?(beyondrelational.com)

submitted by ashish.gilhotraashish.gilhotra(354) 1 year, 6 months ago

Every so often on the on-line forums, the question of : Which is better Count(*) or Count(1) ? will occur. So can it categorically be proved than one is better than the other ? What we need to do is populate a table and use both count(*) and count(1) and see if we get any performance difference between the two.

add a comment |category: |Views: 668

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
brianclintwudbrianclintwud(55) - anilnairanilnair(0) - rsivamrsivam(0) - andreasandreas(10)
More who kicked this story...
Comments:
information Login or create an account to comment on this story
Submit a Story
View upcoming stories
How else can I help?
Add our feeds to your site

Most Active Users

What's this?