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 are aggregate tables? How do you design them using teradata?
Comment whether bottleneck is an error or not.
If RDBMS is halted what will you do ?
Explain teradata vs. Redshift?
Can you connect multiload from ab initio?
What is called partitioned primary index (ppi)?
What are the available primary index types?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Which is more efficient group by or distinct to find duplicates?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
how do you manage the production space. what are the proactive methods you can take ?
What is the purpose of indexes?
What are the different softwares used with their functions in teradata?
What is meant by a node?