Pls any body reply for this question.
Which circumstance does the optimizing choose a product join?
Thanks for advance
Answer Posted / shaik mahamad rafi
When ever we write the join for retrieve the data from two or more tables ,the alias names should be no matching data type to the join columns ,the optimizer produces Product join
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What tools would you use for that?
Did you write stored procedures in teradata?
Explain amp in teradata?
What are some commonly used bteq scripts?
What is inner join and outer join?
What is the purpose of joins in teradata and what are the available join types?
What are the components used in smp and massively parallel processing (mpp) machines?
What is a three-tier data warehouse?
What are the uses of bynets in multi-node systems?
What are teradata utilities?
What is the syntax for case when statement?
What is node? How many nodes and amps used in your previous project?
What do you mean by fastexport in teradata?
How can bottlenecks be identified?
What are the different functions included in the server software?