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 consistency token
When is the skeleton cursor table created?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
Which catalog tables contain authorization information?
How will fetch last 5 rows from table in db2
What is an alias and how does it differ from a synonym?
What are the various locks available?
What is precompiler in db2?
What is the difference between drop table and delete table?
Define data page.
Can you use max on a char column?
What is the purpose of the WHENEVER statement?