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

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.