Interested to Buy Any Domain ? << Click Here >> for more details...
What is the default join strategy in Teradata???
- 5 Answers
- 25421 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / dg
The Teradata Cost based optimizer will decide the join
strategy based on the optimum path. The common startegies
followed are from Merge, Hash & Nested Join
| Is This Answer Correct ? | 25 Yes | 3 No |
Answer / 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 |
Answer / tdguy
i think there is no "default" join strategy. Optimizer
decides the type of strategy based on the best retrieval
path and other parameters to execute the query. Merge join
strategy, nested join strategy, hash join strategy and
product join strategies are the common strategies followed
by TD.
| Is This Answer Correct ? | 7 Yes | 1 No |
What are the various indexes in teradata? How to use them? Why are they preferred?
What are the steps to create a data model?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Explain and compare pros and cons of snow flake schemas?
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?
what is the difference between start schma and Fsldm?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
Which Teradata concept allows more than one model generation?
what is the difference between filter and router transmissions
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
If RDBMS is halted what will you do ?
How is Teradata in current market?
Teradata 
