What is the default join strategy in Teradata???

Answers were Sorted based on User's Feedback



What is the default join strategy in Teradata???..

Answer / 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

What is the default join strategy in Teradata???..

Answer / yuvaevergreen

Three strategies followed by optimizer are:
1.Duplication of rows of one table to every amp
--> This one is opted by optimizer when the non-PI column
is on a small table.
2.Redistribution of the non PI rows of the table to the amp
containing the matching PI row amp.
--> This one is opted when the tables are large. The non PI
column is in one table is redistributed to the amp
containing the matching PI.
3.Redistribute both the rows of the table by hash values.
--> This is chosen when the join is on a column that is not
the PI in either table. This will require the most spool
space.

Is This Answer Correct ?    13 Yes 3 No

What is the default join strategy in Teradata???..

Answer / 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

What is the default join strategy in Teradata???..

Answer / ankal

Merge join is the default join strategy

Is This Answer Correct ?    2 Yes 9 No

What is the default join strategy in Teradata???..

Answer / prakash

product join is the default join strategy

Is This Answer Correct ?    0 Yes 12 No

Post New Answer

More Teradata Interview Questions

Explain the teradata primary index mechanics in detail with a diagram.

0 Answers  


How to find duplicates in a table?

0 Answers  


How do you set the session mode parameters in bteq?

0 Answers  


Explain vproc in teradata?

0 Answers  


Discuss the advantages of using partitioned primary index in a query?

0 Answers  






Differentiate primary key and partition key?

0 Answers  


id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???

6 Answers   Cap Gemini,


Explain amp in teradata?

0 Answers  


What do you mean by fastexport in teradata?

0 Answers  


sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?

3 Answers   CTS,


What is the use of teradata system software?

0 Answers  


What is the multi-insert?

0 Answers  


Categories