Pls any body reply for this question.
Which circumstance does the optimizing choose a product join?
Thanks for advance
- 6 Answers
- 12870 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / shaik mahamad rafi
When ever we write the join for retrieve the data from two or more tables ,the alias names should be no matching data type to the join columns ,the optimizer produces Product join
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a level of granularity of a fact table?
What is smp and mpp platforms?
What are the different design perspectives used in teradata?
how many modules are there in telecome domain?how to explain the architecture?
How do you verify a complicated sql?
What is meant by a dispatcher?
Describe primary index in teradata?
What is teradata and why it is used?
What are the available join types in teradata?
how can we analyze the locks ?
What is real time and near real time data warehousing?
What are the steps involved in the process flow of the sql statement through channel attached system?
What is meant by a node?
Explain the term 'row' related to relational database management system?
What are the various indexes in teradata? How to use them?
