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
- 14006 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
What are default access rights in teradata? What explicit right can be given to a user?
How to view every column and the columns contained in indexes in teradata?
What are the design features involved in teradata?
Differentiate primary key and partition key?
Can you fastexport a field, which is primary key by putting equality on that key?
Explain fastload in teradata?
What are the different functions performed in development phase?
Explain the term 'tables' related to relational database management system?
What is a clique?
What do you mean by teradata intelliflex?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
Steps to create a data model?
During the Display time, how is the sequence generated by Teradata?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What are the uses of client software involved in teradata?
