What is the default join strategy in Teradata???
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 the Primary Index, what is the score of AMPs that are actively involved?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Explain PDE.
What are the various indexes in teradata? Why are they preferred?
Highlight the points of differences between the database and user in Teradata.
What are the steps involved after the disk manager passes the request?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What are the joins in teradata?
What tools would you use for that?
Did you write stored procedures in teradata?
When tpump is used instead of multiload?
Explain parsing engine in teradata?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What is a node in teradata? Explain