When setting optimizer hints,____ instructs the optimizer to minimize the overall execution time,that is,to minimize the time it takes to return all 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 hint "ALL_ROWS" instructs the optimizer to minimize the overall execution time, which is what is needed for batch mode processes. Option B "FIRST_ROWS" is used when the goal is to return the first few rows as quickly as possible. Option C "INDEX(P_QOH_NDX)" is not an optimizer hint, but rather an index hint telling the optimizer to use a specific index. Option D "OPTIMIZATION_ROWS" is not a valid optimizer hint.

When Setting Optimizer Hints,____ Instructs the Optimizer to Minimize the Overall