which DQL hint will the first N rows of a query be returned quickly?

seenagape

10 years ago

With which DQL hint will the first N rows of a query be returned quickly?

A.
OPTIMIZATION_LEVEL N

B.
OPTIMIZE_TOP N

C.
FORCE_ORDER N

D.
ROW_BASED N