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 the new features of teradata?
What is difference between user and database in teradata?
What is meant by a Least Cost Plan?
Explain amp in teradata?
How will you solve the problem that occurs during update?
What do high confidence, low confidence and no confidence mean in explain plan?
What can be achieved by using the teradata rdbms?
Why teradata is used?
What is the opening step in basic teradata query script?
Highlight a few of the important components of Teradata?
Highlight the differences between Primary Key and Primary Index.
What do you mean by fastexport in teradata?
What is a clique?
What are the multiload utility limitations?
Syntax for case when statement?