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))
Explanation: