Pls any body reply for this question.
Which circumstance does the optimizing choose a product join?
Thanks for advance
- 6 Answers
- 12480 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
What do you mean by parsing?
How do you see a ddl for an existing table?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What is smp and mpp platforms?
Differentiate database data and data warehouse data?
What are the different table types supported by teradata?
Explain the new features of teradata?
Difference between stored procedure and macro?
Highlight the points of differences between the database and user in Teradata.
Can we collect statistics on multiple columns?
What is the basic syntax for teradata select statement?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Explain the term 'row' related to relational database management system?
Explain and compare pros and cons of start schemas?
Define views in teradata with syntax.
