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
- 14237 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
How will you solve the problem that occurs during update?
What is the purpose of indexes?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What are types of partition primary index (ppi) in teradata?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What are differences between teradata and ansi session modes in teradata?
What is multi insert?
Mention a few of the ETL tools that come under Teradata.
What is the basic syntax for teradata select statement?
What are the components used in smp and massively parallel processing (mpp) machines?
What is logical data model?
What are the functions of a teradata dba?
what is object level locking ? where do appear this type of locking ?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
