What is the default join strategy in Teradata???
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
Write a program to show the parser component used in teradata?
What do you mean by teradata sql assistant?
What is the syntax for case when statement?
What is oltp?
What are the components provided on node?
What are the design features involved in teradata?
Explain PDE.
Highlight the advantages of PPI(Partition Primary Index).
What do you mean by teradata intellicloud?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What can be achieved by using the teradata rdbms?
What exactly do you know about catching in teradata?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What are the updated features of teradata?
What are the different functions performed in development phase?