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
- 14391 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
In general, how do you optimze any sql in teradata?
What are the newly developed features of Teradata?
How many sessions of MAX is PE capable of handling at a particular time?
What are the various indexes in teradata? Why are they preferred?
When tpump is used instead of multiload?
What is oltp?
During the Display time, how is the sequence generated by Teradata?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
Explain the term 'foreign key' related to relational database management system?
How to find duplicates in a table?
What is collect statistics?
What do you mean by ttu in teradata?
What is the difference between union and union all in teradata?
if collect stats but it show low confidence why?
What is the primary index in teradata?
