Which DQL hint could be used to help to optimize a complex query where the join seems to be the major bottleneck?
A. INDEX
B. RETURN_TOP
C. FORCE ORDER
D. OPTIMIZE_TOP
Which DQL hint could be used to help to optimize a complex query where the join seems to be the major bottleneck?
A. INDEX
B. RETURN_TOP
C. FORCE ORDER
D. OPTIMIZE_TOP