Interested to Buy Any Domain ? << Click Here >> for more details...
What is a Cartesian product?
- 2 Answers
- 10322 Views
- I also Faced
- E-Mail Answers
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 |
Where is the output of EXPLAIN stored?
What is dbrm? What it contains? When it will be created?
Define check constraint.
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
what is difference between Plan and Package
What does it mean if the null indicator has -1, 0, -2?
What's the maximum number of characters that a tablename can have?
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
What is syscat in db2?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
What is deadlock in db2?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
COBOL 
