InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is A Cartesian Product? What Causes It? |
|
Answer» A Cartesian product is the result of an UNRESTRICTED join of TWO or more tables. The result set of a three table Cartesian product will have X * y * z number of ROWS where x, y, z correspond to the number of rows in each table involved in the join. It is causes by specifying a table in the FROM clause without joining it to ANOTHER table. A Cartesian product is the result of an unrestricted join of two or more tables. The result set of a three table Cartesian product will have x * y * z number of rows where x, y, z correspond to the number of rows in each table involved in the join. It is causes by specifying a table in the FROM clause without joining it to another table. |
|