EnsurepassQUESTION 81 You have been tasked to write a query to select one million rows. You need to optimize the query to return the first 50 rows as quickly as possible. What query hint should you use?   A. FAST 50 B. MAXDOP 50 C. OPTIMIZE FOR @ROWS=50 D. TABLE HINT(table, INDEX(50))   Correct Answer: A Explanation: 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 Read more [...]