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


Please Help Members By Posting Answers For Below Questions

What is the primary index in teradata?

582


What is a level of granularity of a fact table?

637


What are the advantages of teradata?

594


What are the functions of a Parser?

602


In BTEQ, how are the session-mode parameters being set?

641






What is database exceptions in teradata?

539


What is the basic syntax for teradata select statement?

572


What is the use of virtual processor connectivity in teradata?

561


Explain how spool space is used.

611


Explain the parallel data extension in teradata?

652


What is the function of parser component in teradata?

616


In Teradata, how do we Generate Sequence?

599


What are differences between teradata and ansi session modes in teradata?

617


How many codd's rules are satisfied by teradata database?

658


What is the difference between global temporary tables and volatile temporary tables?

629