What is the default join strategy in Teradata???
- 5 Answers
- 24291 Views
- IBM, I also Faced
- E-Mail Answers
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
In the Primary Index, what is the score of AMPs that are actively involved?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What is the syntax for case when statement?
What is the difference between fastload and multiload?
What is bteq utility in teradata?
What is the use of fallback?
What is meant by a Highest Cost Plan?
During the Display time, how is the sequence generated by Teradata?
what are the day to day activities of teradata DBA ?
What is the use of teradata system software?
Explain PDE.
Is multi insert ansi standard?
What are the steps involved after the disk manager passes the request?
What are the different functions included in the server software?
How is MLOAD Client System restarted after execution?
