Interested to Buy Any Domain ? << Click Here >> for more details...
Pls any body reply for this question.
Which circumstance does the optimizing choose a product join?
Thanks for advance
- 6 Answers
- 14002 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Highlight a few of the important components of Teradata?
What is called partitioned primary index (ppi)?
What are the functions of a teradata dba?
What are the available join types in teradata?
What is meant by a Clique?
What are differences between teradata and ansi session modes in teradata?
In Teradata, what is the significance of UPSERT command?
What is the purpose of joins in teradata?
What do you mean by teradata intelliflex?
Explain some differences between mpp and smp?
What are the various reporting tools in the market?
What is the use of fallback?
What are the string manipulation operators and functions associated with teradata?
What is a dimension table?
