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
- 14410 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
What is database exceptions in teradata?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
How you will check the version of teradata?
How do you set the session mode parameters in bteq?
List out all forms of LOCKS that are available in Teradata.
How to identify ppi columns?
What are the various etl tools in the market?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What is a level of granularity of a fact table?
Explain some differences between mpp and smp?
In the Primary Index, what is the score of AMPs that are actively involved?
What are the various reporting tools in the market?
Explain fastload in teradata?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
How do you verify a complicated sql?
