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
- 14004 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / charan
Actually we never use Product join in Real time of teradata. because it occupies more spool space and more rows it will be give.so, we dont use product join.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What are the different design perspectives used in teradata?
What are default access rights in teradata? What explicit right can be given to a user?
What is the purpose of using case expression in teradata?
What is teradata? What are some primary characteristics of teradata?
What are the available primary index types in teradata.
What are different table types used in teradata?
Explain the advantages of partitioned primary index in a query?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What do you mean by tpt in teradata?
What are the different table types that are supported by teradata?
What do you mean by fastexport in teradata?
What are the main components of teradata system?
How you will check the version of teradata?
How do you do backup and recovery in teradata?
