What is the default join strategy in Teradata???
Answer Posted / dg
The Teradata Cost based optimizer will decide the join
strategy based on the optimum path. The common startegies
followed are from Merge, Hash & Nested Join
| Is This Answer Correct ? | 25 Yes | 3 No |
Post New Answer View All Answers
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What is the meaning of Caching in Teradata?
What is the difference between fastload and multiload? Which one is faster?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Why is the case expression used in teradata?
Steps to create a data model?
What are some commonly used bteq scripts?
What are normalization, first normal form, second normal form and third normal form?
How is MLOAD Teradata Server restarted after execution?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
Explain the advantages of partitioned primary index in a query?
What are some primary characteristics of teradata?
What is the command in bteq to check for session settings ?
How do you set the session mode parameters in bteq?
Difference between inner join and outer join?