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
- 14243 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
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What type of indexing mechanism do we need to use for a typical data warehouse?
In Teradata, what is the significance of UPSERT command?
How do you see a ddl for an existing table?
What are the design features involved in teradata?
What do you mean by teradata intellicloud?
What are the steps involved in the process flow of the sql statement through channel attached system?
What are some primary characteristics of teradata?
What does sleep function does in fast load?
What is logical data model?
Write a program to show the parser component used in teradata?
How does hashing happens in teradata?
What are the 5 phases in a multiload utility?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What's the difference between timestamp (0) and timestamp (6)?
