What is the default join strategy in Teradata???
- 5 Answers
- 23431 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
What is a node in teradata? Explain
What is bteq utility in teradata?
What are default access rights in teradata?
What is primary index and secondary index?
Difference between inner join and outer join?
How do you see a ddl for an existing table?
What is the command in bteq to check for session settings ?
What exactly do you know about catching in teradata?
What is meant by a node?
What are the advantages of teradata?
Syntax for case when statement?
Describe the set operators in teradata.
How do you verify a complicated sql?
What does sleep function does in fast load?
Difference between multiload and tpump?
