Pls any body reply for this question.
Which circumstance does the optimizing choose a product join?
Thanks for advance
Answer Posted / yuvaevergreen
Product join in not desirable unless required as it involves
over usage and unnecessary usage of resources. The query
designer should always use conditions in the query or sub
queries to reduce the no of qualifying rows. This can be
easily observed by analyzing the execution plan. So TD
assumes "product join" when there are tables involved
without any condition. Example below,
SELECT * FROM A,B;
Since no filtering condition has been used, this results in
a product join.
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Explain vproc in teradata?
Highlight a few of the advantages that ETL tools have over Teradata.
Highlight the differences between Primary Key and Primary Index.
What are differences between teradata and ansi session modes in teradata?
What is basic teradata query language?
How to identify ppi columns?
What are the functions of a Parser?
Which is more efficient group by or distinct to find duplicates?
What is a sparse index?
Explain teradata vs. Redshift?
What are some commonly used bteq scripts?
What is the difference between teradata and oracle?
What do you mean by caching in teradata?
What is difference between user and database in teradata?
What are the different table types that are supported by teradata?