Pls any body reply for this question.
Which circumstance does the optimizing choose a product join?
Thanks for advance
- 6 Answers
- 12874 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / etlguy
Product join compares all rows in 1st table with rows in 2nd
table. This join is generally chosen by optimizer whenever
there in an inequality condition in join. This is because
hash values cannot be compared for greater than or lesser
than which results in product join. Also, product join uses
spool files for redistribution or duplication of tables,
which is not desirable.So, it is advisable to avoid product
join as far as possible.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Difference between stored procedure and macro?
How to find duplicates in a table?
Discuss the advantages of using partitioned primary index in a query?
What is bteq utility in teradata?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What are the multiload utility limitations?
What are the things to be considered while creating secondary index?
What are the advantages of teradata?
what is object level locking ? where do appear this type of locking ?
If RDBMS is halted what will you do ?
How to identify ppi columns?
What are the scenarios in which full table scans occurs?
In Teradata, what is the significance of UPSERT command?
