Pls any body reply for this question.
Which circumstance does the optimizing choose a product join?
Thanks for advance
- 6 Answers
- 12873 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
Can you connect multiload from ab initio?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What are the different softwares used with their functions in teradata?
What is stored procedure in teradata?
What are default access rights in teradata? What explicit right can be given to a user?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What exactly do you know about catching in teradata?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Explain the term 'row' related to relational database management system?
What are the scenarios in which full table scans occurs?
What tools would you use for that?
What does sleep function does in fast load?
How do you set the session mode parameters in bteq?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What is the meaning of Caching in Teradata?
