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
- 14397 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / ab75150
Product join occurs in 2 circumstances.
1) Your stats are out-dated
2) One table is a substantially huge and the other is very
small. In that case, optimizer identifies that is better to
replicate the smaller tables across all amps and then
complete the join.
In later case, product join is not bad. but if the stats
are outdate, better refresh the stats and go ahead with the
execution.
Incase your stats are good and still optimizer goes the
product join path, if you really want to avoid it, you may
force the optimizer not to choose it with following command
DIAGNOSTIC NOPRODJOIN ON FOR SESSION
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What are the updated features of teradata?
How can you track login parameters of users in teradata?
What is the use of stored procedures in teradata?
What do you mean by fastexport in teradata?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What are the different softwares used with their functions in teradata?
How to select first n records in teradata?
How is MLOAD Client System restarted after execution?
What are the different functions included in the server software?
How to eliminate product joins in a teradata sql query?
What is inner join and outer join?
What do you mean by caching in teradata?
Highlight a few of the important components of Teradata?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
