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 function of parser component in teradata?
How to select first n records in teradata?
List out all forms of LOCKS that are available in Teradata.
What are some commonly used bteq scripts?
What are the joins in teradata and how many types of joins are there in teradata?
What do you mean by ttu in teradata?
What is difference between user and database in teradata?
Comment whether bottleneck is an error or not.
What are default access rights in teradata?
Explain the teradata primary index mechanics in detail with a diagram.
What is upsert statement in teradata?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What is the meaning of Caching in Teradata?
What happens when a node suffers a downfall?