title: Performance difference: select top 1 order by vs. select min(val)
body: <p>Question is simple. Which query will be faster:</p>
  
  <pre><code>SELECT TOP 1 value FROM table ORDER BY value
  </code></pre>
  
  <p>or</p>
  
  <pre><code>SELECT TOP 1  MIN(value) FROM table
  </code></pre>
  
  <p>We can assume that we have two cases, Case 1. No index and Case 2. With index on value.
  <br/>Any insights are appreciated. Thanks! </p>