Interested to Buy Any Domain ? << Click Here >> for more details...
Pls any body reply for this question.
Which circumstance does the optimizing choose a product join?
Thanks for advance
- 6 Answers
- 14241 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
Highlight the advantages of PPI(Partition Primary Index).
What are the components used in smp and massively parallel processing (mpp) machines?
How to load specific no.of records using bteq, or fastload,or multiload
Explain the term 'tables' related to relational database management system?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
How to select first n records in teradata?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
In Teradata, how do we Generate Sequence?
How is the teradata different from oracle?
What is the meaning of Caching in Teradata?
What are differences between teradata and ansi session modes in teradata?
What is the use of virtual processor connectivity in teradata?
What are the scenarios in which full table scans occurs?
What are the different functions performed in development phase?
Explain parsing engine in teradata?
