What is a Cartesian product?
Answers were Sorted based on User's Feedback
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?
What is db2 catalog database?
What is a subselect? Is it different from a nested select?
What are simple, segmented and partitioned table spaces ?
How to resolve deadlock issue
How can the duplicate values be eliminated from db2 select?
What is bind plan?
What is multi row fetch in db2?
Which command is used to connect to a database in DB2 ? Give the Syntax.
Explain about mirror activator disk mirroring?
What keyword does an SQL SELECT statement use for a string search?
can you use symbolic parameters in JOB?