Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


boostr.in questions - 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

asked Sep 13, 2013 in MYSQL by anonymous
edited Sep 12, 2013
0 votes
12 views



Related Hot Questions



Walkin Jobs Opening



Government Jobs Opening


...