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
- 14001 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 many tables can you join in v2r5?
What are tpump utility limitations?
What are the frequently used data types in teradata?
Explain the types of join supports by teradata?
What is meant by a Virtual Disk?
During the Display time, how is the sequence generated by Teradata?
What are the commands to make a new table, change a table and remove a table in teradata?
How to view every column and the columns contained in indexes in teradata?
What are the different softwares used with their functions in teradata?
What is oltp?
What is teradata? What are some primary characteristics of teradata?
What is the opening step in basic teradata query script?
In the Primary Index, what is the score of AMPs that are actively involved?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What is the difference between fastload and multiload?
