What query hint should you use?

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?

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:



Leave a Reply 0

Your email address will not be published. Required fields are marked *