What is the default join strategy in Teradata???
Answer Posted / 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 |
Post New Answer View All Answers
What is logical data model?
What are the various indexes in teradata? How to use them? Why are they preferred?
List out teradata data types?
Write a program to show the parser component used in teradata?
What is the purpose of upsert command?
What is bteq utility in teradata?
What is bteq script in teradata?
What is real time and near real time data warehousing?
What are the different functions performed in development phase?
What is meant by Teradata Gateway?
Can we collect statistics on multiple columns?
What is meant by a Parsing Engine?
Can we collect statistics on table level?
What is the difference between teradata and basic rdbms?
What are the frequently used data types in teradata?