Interested to Buy Any Domain ? << Click Here >> for more details...
What is the default join strategy in Teradata???
- 5 Answers
- 25586 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / tdguy
i think there is no "default" join strategy. Optimizer
decides the type of strategy based on the best retrieval
path and other parameters to execute the query. Merge join
strategy, nested join strategy, hash join strategy and
product join strategies are the common strategies followed
by TD.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What are the joins in teradata and how many types of joins are there in teradata?
In Teradata, how do we Generate Sequence?
What are the string manipulation operators and functions associated with teradata?
What is partitioned primary index (ppi)?
Explain teradata architecture?
Why does varchar occupy 2 extra bytes?
How to identify ppi columns?
How can bottlenecks be identified?
What is the meaning of Caching in Teradata?
What is teradata and why it is used?
Explain the term 'foreign key' related to relational database management system?
What is the difference between teradata and basic rdbms?
What is a node in teradata? Explain
How many tables can you join in v2r5?
What happens in a conflict? How do you handle that?
