When setting optimizer hints,____ instructs the optimizer to minimize the time it takes to process the first set of rows,that is,to minimize the time it takes to return only the first set of rows in the query result set.This hint is generally used for interactive mode processes.
A) ALL_ROWS
B) FIRST_ROWS
C) INDEX(P_QOH_NDX)
D) OPTIMIZATION_ROWS

Question

Quizplus · Accepted Answer

The FIRST_ROWS hint instructs the optimizer to prioritize minimizing the time it takes to process the first set of rows in the query result set, which is useful for interactive mode processing. The other options are either incorrect or do not prioritize the same functionality as required in this scenario.

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