title: Which is faster: Sum(Case When) Or Group By/Count(*)?
body: <p>I can write</p>
  
  <pre><code>Select 
  Sum(Case When Resposta.Tecla = 1 Then 1 Else 0 End) Valor1,
  Sum(Case When Resposta.Tecla = 2 Then 1 Else 0 End) Valor2,
  Sum(Case When Resposta.Tecla = 3 Then 1 Else 0 End) Valor3,
  Sum(Case When Resposta.Tecla = 4 Then 1 Else 0 End) Valor4,
  Sum(Case When Resposta.Tecla = 5 Then 1 Else 0 End) Valor5
  From Resposta
  </code></pre>
  
  <p>Or</p>
  
  <pre><code>Select 
      Count(*)
  From Resposta Group By Tecla
  </code></pre>
  
  <p>I tried this over a large number of rows and it seems like taking the same time. </p>
  
  <p>Anyone can confirm this?</p>