What is the default join strategy in Teradata???
- 5 Answers
- 23430 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
Explain amp in teradata?
What is teradata?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
Is multi insert ansi standard?
How to find duplicates in a table?
How will you solve the problem that occurs during update?
What do you mean by teradata intelliflex?
What is teradata? What are some primary characteristics of teradata?
What are aggregate tables? How do you design them using teradata?
How do you see a ddl for an existing table?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
List out some of the primary characteristics of teradata.
What are the functions involved in shared information architecture?
Explain teradata vs. Redshift?
