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
Explain the term 'tables' related to relational database management system?
What are normalization, first normal form, second normal form and third normal form?
how do you manage the production space. what are the proactive methods you can take ?
What is database exceptions in teradata?
Explain the term 'primary key' related to relational database management system?
In Teradata, what is the significance of UPSERT command?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What are the various indexes in teradata?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What's the difference between timestamp (0) and timestamp (6)?
What do you mean by ttu in teradata?
Mention a few of the ETL tools that come under Teradata.
Explain the new features of teradata?
What are some commonly used bteq scripts?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com