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
- 6 Answers
- 14411 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / etlguy
Product join compares all rows in 1st table with rows in 2nd
table. This join is generally chosen by optimizer whenever
there in an inequality condition in join. This is because
hash values cannot be compared for greater than or lesser
than which results in product join. Also, product join uses
spool files for redistribution or duplication of tables,
which is not desirable.So, it is advisable to avoid product
join as far as possible.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are teradata utilities?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What is TPD?
What is dimensional modeling?
what is object level locking ? where do appear this type of locking ?
What are the functions performed by bynet?
Explain the advantages of partitioned primary index in a query?
What do you mean by tpt in teradata?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What is the difference between teradata and oracle?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What are the different table types that are supported by teradata?
How to select first n records in teradata?
What are the various etl tools in the market?
What is node? How many nodes and amps used in your previous project?
