Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Write a program to show the parser component used in teradata?

977


What do you mean by teradata sql assistant?

1062


What is the syntax for case when statement?

1144


What is oltp?

977


What are the components provided on node?

1043


What are the design features involved in teradata?

1058


Explain PDE.

1083


Highlight the advantages of PPI(Partition Primary Index).

1078


What do you mean by teradata intellicloud?

1038


If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2204


What can be achieved by using the teradata rdbms?

1038


What exactly do you know about catching in teradata?

1038


How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1776


What are the updated features of teradata?

1046


What are the different functions performed in development phase?

1080