What is a Cartesian product?

Answers were Sorted based on User's Feedback



What is a Cartesian product?..

Answer / m4io

a cartesian product is a join between two tables where
the join-condition + where-conditions do not deliver a
unique key on either table.
it is a n*m relationship.

Not necessarily faulty (Star joins use cartesian products)

Is This Answer Correct ?    4 Yes 1 No

What is a Cartesian product?..

Answer / sunil1405

A Cartesian product results from a faulty query. It is a
row in the results for every combination in the join
tables.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More DB2 Interview Questions

what is datacom db?

2 Answers   CSC,


Can there be more than one cursor open for any program?

0 Answers  


Define predicate?

0 Answers  


What is copy pending and check pending in db2?

0 Answers  


What is a clustering index?

2 Answers  






When is the authorization check on DB2 objects done - at BIND time or run time?

1 Answers  


How can deadlocks be resolved?

0 Answers  


what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,


How do you stop a db2 database in linux?

0 Answers  


Where is the output of EXPLAIN stored?

2 Answers  


Why cursor is used in db2?

0 Answers  


What is plan in cobol db2?

0 Answers  


Categories