Pre Exam Test Practice (SSC | Banking | IAS | GATE | State Level | CLAT | Railways | Insurance | Teaching Exams | NDA | Defence | IES |State Exam )

Organizational Research By

Surprising Reserch Topic 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

Related Hot Questions

Government Jobs Opening