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

Describe primary index in teradata. And what are the available primary index types?

547


What is difference between user and database in teradata?

618


What are the different methods ot loading a dimension table? A fact table etc?

576


What is the command in bteq to check for session settings ?

634


What is the maximum number of dml can be coded in a multiload script?

621






Did you write stored procedures in teradata?

617


Different phases of multiload?

594


Can you fastexport a field, which is primary key by putting equality on that key?

709


My table got locked during mload due to a failed job. What do I do to perform other operations on it?

680


What is meant by Teradata Gateway?

582


Explain how spool space is used.

615


Give the sizes of SMALLINT, BYTEINT and INTEGER.

664


List the logical and conditional operators that are used with teradata along with their meanings?

554


What is inner join and outer join?

615


What are the primary characteristics of the Teradata.

591