Pls any body reply for this question.
Which circumstance does the optimizing choose a product join?
Thanks for advance
- 6 Answers
- 12871 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
Highlight the advantages of PPI(Partition Primary Index).
What are the functions of a teradata dba?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What do you mean by teradata intelliflex?
What happens when a node suffers a downfall?
What are the frequently used data types in teradata?
What is the use of having index on table?
What is called partitioned primary index (ppi)?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What is bteq utility in teradata?
What is the use of teradata system software?
What do you mean by teradata intellicloud?
What are the main components of teradata system?
Can you connect multiload from ab initio?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
