BETTER query and faster : <p>i would like to ask between these two query, what query is faster? if the data is 20k to 100k..</p>

<pre><code>SELECT SUM(price * quantity) as sales
FROM
(
  SELECT price, quantity, date
  FROM orderline
  UNION ALL
  SELECT price, quantity, date
  FROM creditorderline
)
WHERE date BETWEEN '2010-01-01' AND '2016-01-01'
</code></pre>

<p>OR</p>

<pre><code>SELECT SUM(price * quantity) as sales
FROM
(
  SELECT price, quantity, date
  FROM orderline
  WHERE date BETWEEN '2010-01-01' AND '2016-01-01'
  UNION ALL
  SELECT price, quantity, date
  FROM creditorderline
 WHERE date BETWEEN '2010-01-01' AND '2016-01-01'
)
</code></pre>
