Pls any body reply for this question.
Which circumstance does the optimizing choose a product join?
Thanks for advance
- 6 Answers
- 12490 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
What are tpump utility limitations?
What is the use of stored procedures in teradata?
Highlight the differences between Primary Key and Primary Index.
Explain the new features of teradata?
What is teradata? Also, list out some of the primary characteristics of teradata.
What is the use of having index on table?
Did you write stored procedures in teradata?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
Can we collect statistics on table level?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Explain teradata architecture?
Define views in teradata with syntax.
Define views in teradata with general syntax.
What is the difference between teradata and basic rdbms?
What are the design features involved in teradata?
