When setting optimizer hints, _____ instructs the optimizer to minimize the overall execution time, that is, to minimize the time it takes to return the total number of rows in the query result set. This hint is generally used for batch mode processes.
A) ALL_ROWS
B) FIRST_ROWS
C) INDEX(P_QOH_NDX)
D) OPTIMIZATION_ROWS

Question

Quizplus · Accepted Answer

The ALL_ROWS hint instructs the optimizer to minimize the overall execution time, which is generally preferred for batch mode processes. The other hints mentioned do not specifically address minimizing execution time for the entire result set.

When Setting Optimizer Hints, _____ Instructs the Optimizer to Minimize