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 / 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

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1111


What is the meaning of Caching in Teradata?

1100


What is the difference between fastload and multiload? Which one is faster?

1164


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

1740


Why is the case expression used in teradata?

1039


Steps to create a data model?

1085


What are some commonly used bteq scripts?

964


What are normalization, first normal form, second normal form and third normal form?

1020


How is MLOAD Teradata Server restarted after execution?

1197


What is spool space? Why do you get spool space errors? How do trouble-shoot them?

951


Explain the advantages of partitioned primary index in a query?

990


What are some primary characteristics of teradata?

961


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

1139


How do you set the session mode parameters in bteq?

1070


Difference between inner join and outer join?

974