Pls any body reply for this question.
Which circumstance does the optimizing choose a product join?
Thanks for advance
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
Differentiate database data and data warehouse data?
Difference between multiload and tpump?
What are the different table types that are supported by teradata?
What are the joins in teradata and how many types of joins are there in teradata?
Did you write stored procedures in teradata?
While creating table my dba has fallback or no fallback in his ddl. What is that?
Describe primary index in teradata?
What is the difference between teradata and oracle?
What is the basic syntax for teradata select statement?
What is teradata and why it is used?
What are the commands to make a new table, change a table and remove a table in teradata?
How is MLOAD Client System restarted after execution?
What do you mean by teradata intelliflex?
What is teradata? Also, list out some of the primary characteristics of teradata.
What are the different table types supported by teradata?