Interested to Buy Any Domain ? << Click Here >> for more details...
What is the default join strategy in Teradata???
- 5 Answers
- 25420 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
What are normalization, first normal form, second normal form and third normal form?
how many modules are there in telecome domain?how to explain the architecture?
Explain the term 'columns' related to relational database management system?
What are the components used in smp and massively parallel processing (mpp) machines?
How many sessions of MAX is PE capable of handling at a particular time?
What are the multiload utility limitations?
What are teradata utilities?
What do you mean by caching in teradata?
Why do you get spool space errors? How do trouble-shoot them?
What is the multi-insert?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
How can we check the version of Teradata that we are using currently?
What is the use of teradata system software?
What are the components provided on node?
How to select first n records in teradata?
