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 are the commands to make a new table, change a table and remove a table in teradata?
What are the design features involved in teradata?
What are some commonly used bteq scripts?
what is sysdba and sysdbc ? which has high priority ?
What are the different softwares used with their functions in teradata?
How to Extract data from multiple legacy systems?
What are the available join types in teradata?
What is the basic syntax for teradata select statement?
What is meant by a Channel Driver?
What is the use of virtual processor connectivity in teradata?
Why does varchar occupy 2 extra bytes?
Can you connect multiload from ab initio?
Explain the meaning of Amp?
What is difference between user and database 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?