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
- 14249 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
In general, how do you optimze any sql in teradata?
Difference between multiload and tpump?
What is dimensional modeling?
What is meant by a Virtual Disk?
What are the scenarios in which full table scans occurs?
Discuss the advantages of using partitioned primary index in a query?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
Explain fallback in teradata?
Can we collect statistics on table level?
What is bteq utility in teradata?
What are the commands to make a new table, change a table and remove a table in teradata?
Explain Teradata performance tuning and optimization?
What are the steps involved in the process flow of the sql statement through channel attached system?
What are the functions involved in shared information architecture?
What is logical data model?
