PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

A.
FAST 50

B.
MAXDOP 50

C.
OPTIMIZE FOR @ROWS=50

D.
TABLE HINT(table, INDEX(50))


Leave a Reply