title: What is the difference between COUNT(*) and COUNT(table.ColumnName)?
body: <p>What is the difference between COUNT(*) and COUNT(table.ColumnName)?</p>
  
  <p>I always thought that it is faster to put a column name as a parameter for <code>COUNT</code>, but now when I think of it I really don't know because <code>*</code> means that the function counts rows, so probably there isn't any difference? Or maybe giving a specific column name even slows the process?</p>