Pls any body reply for this question.
Which circumstance does the optimizing choose a product join?
Thanks for advance
- 6 Answers
- 12874 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 the different softwares used with their functions in teradata?
What is a three-tier data warehouse?
What are the commands to make a new table, change a table and remove a table in teradata?
What is the purpose of joins in teradata?
What are the frequently used data types in teradata?
What are the advantages of teradata?
Why managing the data is important?
How you will check the version of teradata?
Can we collect statistics on table level?
What are the newly developed features of Teradata?
How is MLOAD Client System restarted after execution?
How do you see a ddl for an existing table?
What is the purpose of joins in teradata and what are the available join types?
What is teradata?
Highlight all the modes that are present under Confidence Level.
