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
- 14000 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
How to select first n records in teradata?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
Describe primary index in teradata?
What tools would you use for that?
What is the use of having index on table?
What do you mean by parsing?
Write a program to show the parser component used in teradata?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What do you mean by teradata sql assistant?
Steps to create a data model?
What are the different functions performed in development phase?
Explain teradata architecture in detail with a diagram.
Why teradata is used?
Explain the types of join supports by teradata?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
