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 function of parser component in teradata?

1130


How to select first n records in teradata?

1159


List out all forms of LOCKS that are available in Teradata.

1008


What are some commonly used bteq scripts?

1056


What are the joins in teradata and how many types of joins are there in teradata?

1055


What do you mean by ttu in teradata?

1081


What is difference between user and database in teradata?

1113


Comment whether bottleneck is an error or not.

1215


What are default access rights in teradata?

1184


Explain the teradata primary index mechanics in detail with a diagram.

1034


What is upsert statement in teradata?

1186


In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1241


how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1781


What is the meaning of Caching in Teradata?

1185


What happens when a node suffers a downfall?

1184