title: How Does SELECT TOP N work in Sybase ASE
body: <p>I was wondering how this query is executed :</p>
  
  <pre><code>SELECT TOP 10 * FROM aSybaseTable
  WHERE aCondition
  </code></pre>
  
  <p>The fact is that this query is taking too much time to return results.
  So I was wondering if the query is smart enough to stop when the results reach 10 rows of if it returns all the possible results and then print only the 10 first rows.</p>
  
  <p>Thanks in advance for your replies !</p>