Interested to Buy Any Domain ? << Click Here >> for more details...
What is the default join strategy in Teradata???
- 5 Answers
- 25384 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
Explain the parallel data extension in teradata?
How can we check the version of Teradata that we are using currently?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What is teradata?
What is called partitioned primary index (ppi)?
How to Extract data from multiple legacy systems?
What is spool space? Why do you get spool space errors?
What is a node in teradata? Explain
Describe the set operators in teradata.
When tpump is used instead of multiload?
What is the maximum number of dml can be coded in a multiload script?
What is the difference between teradata and basic rdbms?
what is object level locking ? where do appear this type of locking ?
Explain the teradata primary index mechanics in detail with a diagram.
Describe primary index in teradata. And what are the available primary index types?
