SQL (Structured Query Language) Question:

What is a Cartesian product?

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.

Read All 172 SQL Questions

Previous Question	Next 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?