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

Pls any body reply for this question.
Which circumstance does the optimizing choose a product join?
Thanks for advance

Answer Posted / shaik mahamad rafi

When ever we write the join for retrieve the data from two or more tables ,the alias names should be no matching data type to the join columns ,the optimizer produces Product join

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain teradata vs. Redshift?

1023


Different phases of multiload?

1016


What is the use of fallback?

996


How do you set the session mode parameters in bteq?

1106


During the Display time, how is the sequence generated by Teradata?

1055


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4373


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

1186


How many codd's rules are satisfied by teradata database?

1112


What are different table types used in teradata?

1044


Define views in teradata with general syntax.

1034


Why teradata is used?

1008


What do you mean by fastexport in teradata?

1002


What is collect statistics?

1001


What is TPD?

1373


Give the sizes of SMALLINT, BYTEINT and INTEGER.

1171