Interested to Buy Any Domain ? << Click Here >> for more details...
What is the default join strategy in Teradata???
- 5 Answers
- 25596 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
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
How many tables can you join in v2r5?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What is TPD?
What exactly do you know about catching in teradata?
What are the frequently used data types in teradata?
Explain how spool space is used.
What are the main components of teradata system?
Why do you get spool space errors? How do trouble-shoot them?
What is teradata?
Describe the between keyword in teradata?
What are types of partition primary index (ppi) in teradata?
Can you connect multiload from ab initio?
What are the components used in smp and massively parallel processing (mpp) machines?
Why teradata is used?
