What is the default join strategy in Teradata???
Answer Posted / 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 |
Post New Answer View All Answers
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Highlight the need for Performance Tuning.
What are the different methods ot loading a dimension table? A fact table etc?
How is MLOAD Teradata Server restarted after execution?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Can we collect statistics on multiple columns?
What is spool space? Why do you get spool space errors?
What is meant by a Parsing Engine?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
Explain parsing engine in teradata?
What does Amp contain and what are all the operations that it performs?
What are the different design perspectives used in teradata?
What are the functions performed by bynet?
List the logical and conditional operators that are used with teradata along with their meanings?
What are the newly developed features of Teradata?