Pls any body reply for this question.
Which circumstance does the optimizing choose a product join?
Thanks for advance
- 6 Answers
- 12482 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
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Explain teradata vs. Redshift?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
How will you solve the problem that occurs during update?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What are the uses of bynets in multi-node systems?
What happens in a conflict? How do you handle that?
What do you mean by teradata sql assistant?
What are the primary characteristics of the Teradata.
What are the different design perspectives used in teradata?
Discuss the advantages of using partitioned primary index in a query?
How is MLOAD Teradata Server restarted after execution?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What is meant by a Least Cost Plan?
How to view every column and the columns contained in indexes in teradata?
