title: Slow query using sum in SQL Server
body: <p>I have a table in SQL Server 2014 with over 15 million rows and 49 columns. A simple query like this takes about 20 seconds to run. Is there any other ways to fine tune it? <code>Date_run</code> and <code>skid</code> are both indexed non clustered.</p>
  
  <pre><code>select skid, sum(price)
  from stocktrack
  where date_run &gt;='2013-2-21'
    and date_run &lt;='2013-3-21'
  group by skid
  </code></pre>