Dell-EMC
E20-465 · Question #67
Which DQL hint could be used to help to optimize a complex query where the join seems to be the major bottleneck?
The correct answer is C. FORCE ORDER. See the full explanation below for the reasoning.
Question
Which DQL hint could be used to help to optimize a complex query where the join seems to be the major bottleneck?
Options
- AINDEX
- BRETURN_TOP
- CFORCE ORDER
- DOPTIMIZE_TOP
How the community answered
(42 responses)- A14% (6)
- B5% (2)
- C74% (31)
- D7% (3)
Community Discussion
No community discussion yet for this question.