SQL (Structured Query Language) Question:

What is a Cartesian product?

SQL Interview Question
SQL Interview Question

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.


Previous QuestionNext Question
You want to determine the location of identical rows in a table before attempting to place a unique index on the table, how can this be done?You are joining a local and a remote table, the network manager complains about the traffic involved, how can you reduce the network traffic?