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
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What are types of partition primary index (ppi) in teradata?
How many tables can you join in v2r5?
What is smp and mpp platforms?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What are the various reporting tools in the market?
What can be achieved by using the teradata rdbms?
What are the available primary index types?
What are the things to be considered while creating secondary index?
How many types of joins are there in teradata?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
what is sysdba and sysdbc ? which has high priority ?
During the Display time, how is the sequence generated by Teradata?
What are the 5 phases in a multiload utility?