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
- 14409 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
What is oltp?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What is the purpose of using case expression in teradata?
What are the different table types that are supported by teradata?
What are the available primary index types?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What are the various indexes in teradata? How to use them? Why are they preferred?
What is a level of granularity of a fact table?
What are the scenarios in which full table scans occurs?
What is node? How many nodes and amps used in your previous project?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
How do you set the session mode parameters in bteq?
What is the function of parser component in teradata?
What is a node in teradata?
What is the difference between fastload and multiload?
