Ask a Question
Advertise on boostr.in
Organizational Research By
Surprising Reserch Topic
Question: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?
a. ¬†¬†¬†¬†¬†¬†¬†The sort-merge join
b. ¬†¬†¬†¬†¬†¬†¬†The nested loops join
c. ¬†¬†¬†¬†¬†¬†¬†This depends on some sort parameter values
d. ¬†¬†¬†¬†¬†¬†¬†This depends on the number of rows in each table
Sep 13, 2013
Sep 12, 2013
to add a comment.
Related Hot Questions
Your name to display (optional):
Email me at this address if my answer is selected or commented on:
Email me if my answer is selected or commented on
Privacy: Your email address will only be used for sending these notifications.
To avoid this verification in future, please