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
- 14003 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
Small correction to my answer mentioned above. Join
mentioned in the statement is actually cartesian product
join. SELECT * FROM A,B will result in cartesian product and
not product join. Product joins would be chosen for join
conditions containing inequality.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why are oltp database designs not generally a good idea for a data warehouse?
how many modules are there in telecome domain?how to explain the architecture?
Write a program to show the parser component used in teradata?
Explain the term 'foreign key' related to relational database management system?
What is the use of teradata system software?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
Explain how spool space is used.
What are the different functions included in the server software?
What is partitioned primary index (ppi)?
Describe the between keyword in teradata?
Highlight the differences between Primary Key and Primary Index.
What are the main components of teradata system?
What is the multi-insert?
What is the meaning of Caching in Teradata?
Which is more efficient group by or distinct to find duplicates?
