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
What is the purpose of joins in teradata and what are the available join types?
Explain PDE.
What are default access rights in teradata? What explicit right can be given to a user?
How do you see a ddl for an existing table?
Highlight a few of the important components of Teradata?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Syntax for case when statement?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What do you mean by ttu in teradata?
Write a program to show the parser component used in teradata?
Why teradata is used?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What are the various reporting tools in the market?
How is MLOAD Teradata Server restarted after execution?
if collect stats but it show low confidence why?