Answer Posted / 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 |
Post New Answer View All Answers
What does runstats do in db2?
What does sqlcabc has?
What is host variable in db2 cobol?
What is the use of value function?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is coalesce in db2?
On which levels locks can be applied?
What is db2 plan table?
what is diffrence b/w file-aid tool and file-aid utility???
What is the maximum number of columns in a db2 table?
What are the uses of db2 optimizer?
How and when does the db2 enforces the unique key?
What is node in db2?
What is clone table?
Where do you specify them?