Explanation: in mysql, when the tables are unindexed, the searches are run through all the possible combinations. in this case, the search space is 8 x 6 = 48, the product of the number of rows.
Q. FROM tbl_1 INNER JOIN tbl_2 WHERE tbl_1.i1 = tbl_2.i2;
β
Correct Answer: (D)
48
Explanation by: Mr. Dubey
in mysql, when the tables are unindexed, the searches are run through all the possible combinations. in this case, the search space is 8 x 6 = 48, the product of the number of rows.
Discussion
Question Analytics
213
Total Visits
3 y ago
Published
Mr. Dubey
Publisher
83%
Success Rate