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

Question

Quizplus · Accepted Answer

The optimizer hint ALL_ROWS is generally used for batch mode processes, which involve large amounts of data and involve longer execution times. The hint instructs the optimizer to choose the execution plan that minimizes the overall response time, even if it means using more resources initially. This is useful when running batch processes such as data warehousing or reporting, where the goal is to get the results as quickly as possible.

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