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
How can we check the version of Teradata that we are using currently?
What are the components provided on node?
What are the different table types that are supported by teradata?
What is the difference between union and union all in teradata?
What is difference between user and database in teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
what is sysdba and sysdbc ? which has high priority ?
What is the use of fallback?
What tools would you use for that?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What are the various etl tools in the market?
What are differences between teradata and ansi session modes in teradata?
How do you define Teradata?
How do you determine the number of sessions?
What exactly do you know about catching in teradata?