The cost-based optimizer can choose between a nested loops join and a sort merge join operation. All tables are analyzed and the OPTIMIZER_MODE is set to FIRST_ROWS. Which execution plan will be the result?

Keep practicing — related questions

• The Oracle optimizer should be controlled in choosing the type of joins
• What is the default value for the OPTIMIZER_MODE initialization parameter?
• In a joiner transformation the following helps in performance
• What is (are) the difference between Lookup, Join and Merge
• What is (are) the difference between Lookup, Join and Merge
• What is the lowest cost partitioning method for parallel stage to sequential stage?
• What is the lowest cost partitioning method for parallel stage to sequential stage?
• Which of the following is not true for joiner?