In standard SQL, the optimizer hintFIRST_ROWS is generally used for _____ mode processes.
A) batch
B) interactive
C) transaction
D) real-time

Question

Quizplus · Accepted Answer

The FIRST_ROWS hint is generally used for interactive mode processes, where the goal is to return the first few rows of a result set as quickly as possible to improve response time for the end user. This hint instructs the optimizer to use a plan that prioritizes returning the first rows quickly, even if it may not be the most efficient plan for the entire query. It is not typically used for batch, transaction, or real-time mode processes.

In Standard SQL, the Optimizer HintFIRST_ROWS Is Generally Used for _____