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

What is the purpose of joins in teradata and what are the available join types?

1001


Explain PDE.

1012


What are default access rights in teradata? What explicit right can be given to a user?

1056


How do you see a ddl for an existing table?

962


Highlight a few of the important components of Teradata?

968


Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

932


Syntax for case when statement?

1007


If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2099


What do you mean by ttu in teradata?

972


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

913


Why teradata is used?

940


While creating table my dba has fallback or no fallback in his ddl. What is that?

1113


What are the various reporting tools in the market?

989


How is MLOAD Teradata Server restarted after execution?

1166


if collect stats but it show low confidence why?

1618