title: Should I use Query Hint Fast number_rows / FASTFIRSTROW?
body: <p>I was reading over the documentation for query hints:
  <a href="http://msdn.microsoft.com/en-us/library/ms181714(SQL.90).aspx" rel="noreferrer">http://msdn.microsoft.com/en-us/library/ms181714(SQL.90).aspx</a></p>
  
  <p>And noticed this:
  FAST number_rows
  Specifies that the query is optimized for fast retrieval of the first number_rows. This is a nonnegative integer. After the first number_rows are returned, the query continues execution and produces its full result set.</p>
  
  <p>So when I'm doing a query like:</p>
  
  <pre><code>Select Name from Students where ID = 444
  </code></pre>
  
  <p>Should I bother with a hint like this? Assuming SQL Server 2005, when should I? </p>
  
  <p>-- edit --</p>
  
  <p>Also should one bother when limiting results:</p>
  
  <pre><code>Select top 10 * from Students OPTION (FAST 10)
  </code></pre>