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


Please Help Members By Posting Answers For Below Questions

Explain the new features of teradata?

676


What is difference between user and database in teradata?

722


What is meant by a Least Cost Plan?

703


Explain amp in teradata?

650


How will you solve the problem that occurs during update?

692






What do high confidence, low confidence and no confidence mean in explain plan?

696


What can be achieved by using the teradata rdbms?

703


Why teradata is used?

659


What is the opening step in basic teradata query script?

676


Highlight a few of the important components of Teradata?

668


Highlight the differences between Primary Key and Primary Index.

708


What do you mean by fastexport in teradata?

643


What is a clique?

682


What are the multiload utility limitations?

676


Syntax for case when statement?

694