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
- 14412 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
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What is meant by a Channel Driver?
What is teradata?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Define views in teradata with syntax.
Why does varchar occupy 2 extra bytes?
How do you see a ddl for an existing table?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What is the syntax for case when statement?
Explain and compare pros and cons of snow flake schemas?
What are the different softwares used with their functions in teradata?
Highlight the differences between Primary Key and Primary Index.
What is the opening step in basic teradata query script?
How many codd's rules are satisfied by teradata database?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
