Interested to Buy Any Domain ? << Click Here >> for more details...
What is the default join strategy in Teradata???
- 5 Answers
- 25144 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
In Teradata, how do we Generate Sequence?
what is sysdba and sysdbc ? which has high priority ?
What is spool space? Why do you get spool space errors?
Explain and compare pros and cons of snow flake schemas?
Difference between inner join and outer join?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What are aggregate tables? How do you design them using teradata?
What are types of partition primary index (ppi) in teradata?
How do you create tables? Exact syntax, and create profiles, users in teradata?
Why do you get spool space errors? How do trouble-shoot them?
What are the available join types in teradata?
What are the steps involved after the disk manager passes the request?
What is logical data model?
What are the functions of a teradata dba?
What is the command in bteq to check for session settings ?
