Currently viewing the category: "misconception"

count(1) vs count(*) – any difference?

By On January 19, 2007 · 4 Comments

A while ago when I started my first job in LA, I was using MSSQL. I was told to never use count(*), and rather to use count(1). Several people insisted this performs better than count(*), and since I really didn’t care to argue or look into it, I just started doing it.

Fast forward [...]

Continue Reading →