What is the default join strategy in Teradata???

Answer Posted / ankal

Merge join is the default join strategy

Is This Answer Correct ?    2 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the available primary index types?

709


What is stored procedure in teradata?

575


In Teradata, what is the significance of UPSERT command?

585


How to eliminate product joins in a teradata sql query?

594


Describe the between keyword in teradata?

607






What are the scenarios in which full table scans occurs?

527


What is inner join and outer join?

606


What are the various indexes in teradata? How to use them?

555


Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

2993


What are the various indexes in teradata? How to use them? Why are they preferred?

586


What are the different table types that are supported by teradata?

533


Explain the teradata primary index mechanics in detail with a diagram.

559


Highlight a few of the advantages that ETL tools have over Teradata.

605


What is basic teradata query language?

626


What is called partitioned primary index (ppi)?

553