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?

The correct answer is A. FAST 50. 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.

Troubleshoot and Optimize Databases

Question

Options

AFAST 50
BMAXDOP 50
COPTIMIZE FOR @ROWS=50
DTABLE HINT(table, INDEX(50))

How the community answered

(50 responses)

A
72% (36)
B
18% (9)
C
6% (3)
D
4% (2)

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 are returned, the query continues execution and produces its full result set.

Topics

#FAST query hint#query optimization#first N rows#query hints

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice