Dell-EMC
E20-465 · Question #78
With which DQL hint will the first N rows of a query be returned quickly?
The correct answer is B. OPTIMIZE_TOP N. See the full explanation below for the reasoning.
Question
With which DQL hint will the first N rows of a query be returned quickly?
Options
- AOPTIMIZATION_LEVEL N
- BOPTIMIZE_TOP N
- CFORCE_ORDER N
- DROW_BASED N
How the community answered
(49 responses)- A12% (6)
- B78% (38)
- C4% (2)
- D6% (3)
Community Discussion
No community discussion yet for this question.