top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Oracle: What is a Cartesian product?

+1 vote
539 views
Oracle: What is a Cartesian product?
posted Mar 9, 2015 by Suchithra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

+1 vote
 
Best answer

A cartesian product is a result from a select statement that returns all the data from both the tables . The result of a cartesian product is due to the unspecifying the where clause for the join select statement.

answer Mar 10, 2015 by Arun Gowda
0 votes

'If two tables in a join query have no join condition, then Oracle returns their Cartesian product. Oracle combines each row of one table with each row of the other.
A Cartesian product always generates many rows and is rarely useful.

For example, the Cartesian product of two tables, each with 100 rows, has 10,000 rows. Always include a join condition unless you specifically need a Cartesian product. If a query joins three or more tables and you do not specify a join condition for a specific pair, then the optimizer may choose a join order that avoids producing an
intermediate Cartesian product.'

answer Mar 9, 2015 by Amit Kumar Pandey
...