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
- 14408 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / charan
Actually we never use Product join in Real time of teradata. because it occupies more spool space and more rows it will be give.so, we dont use product join.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How is MLOAD Teradata Server restarted after execution?
What is teradata and why it is used?
What is bteq utility in teradata?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
List out all forms of LOCKS that are available in Teradata.
What are the steps to create a data model?
What do high confidence, low confidence and no confidence mean in explain plan?
What is the primary index in teradata?
What is the purpose of joins in teradata?
What happens in a conflict? How do you handle that?
What is inner join and outer join?
What do you mean by tpt in teradata?
How to identify ppi columns?
What is bteq script in teradata?
What are the enhanced features in teradata v2r5 and v2r6?
