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
Explain teradata vs. Redshift?
Different phases of multiload?
What is the use of fallback?
How do you set the session mode parameters in bteq?
During the Display time, how is the sequence generated by Teradata?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
While creating table my dba has fallback or no fallback in his ddl. What is that?
How many codd's rules are satisfied by teradata database?
What are different table types used in teradata?
Define views in teradata with general syntax.
Why teradata is used?
What do you mean by fastexport in teradata?
What is collect statistics?
What is TPD?
Give the sizes of SMALLINT, BYTEINT and INTEGER.