Cartesian product

A situation in which a query includes two or more tables that are not linked by a join. If executed, this type of query retrieves all possible combinations between each table and may lead to inaccurate results.
  • Interview Candidate
  • 8
  • 4245

Showing Answers 1 - 8 of 8 Answers

rrl

  • Oct 15th, 2005
 

In relational algebra, cartesian product between two tables is the result obtained by joining every row of one table with all the rows of another table

  Was this answer useful?  Yes

sithusithu

  • Jan 30th, 2006
 

A Cartesian join will get you a Cartesian product. A Cartesian join is when you join every row of one table to every row of another table. You can also get one by joining every row of a table to every row of itself.

Cheers,

Sithu

  Was this answer useful?  Yes

Reen

  • Oct 10th, 2007
 

Cartesan product is the result of a query when the two tables are not joined by any type of join. All the possible combinations of one table are displayed with the other table just like a cartesan product in algebra

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions