-
Suppose Person is a table consisting of 8 rows and Employee is a table consisting of 6 rows, the number of combinations through which the search is performed is __________.
SELECT Person.i1, Employee.i2
FROM Person INNER JOIN Employee
WHERE Person.i1 = Employee.i2;
-
- 1
- 14
- 48
- 84
- None of these
Correct Option: C
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.
