Pls any body reply for this question.
Which circumstance does the optimizing choose a product join?
Thanks for advance
- 6 Answers
- 12483 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
Product join in not desirable unless required as it involves
over usage and unnecessary usage of resources. The query
designer should always use conditions in the query or sub
queries to reduce the no of qualifying rows. This can be
easily observed by analyzing the execution plan. So TD
assumes "product join" when there are tables involved
without any condition. Example below,
SELECT * FROM A,B;
Since no filtering condition has been used, this results in
a product join.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Explain and compare pros and cons of snow flake schemas?
Highlight the need for Performance Tuning.
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
How will you solve the problem that occurs during update?
how many modules are there in telecome domain?how to explain the architecture?
What does sleep function does in fast load?
What is stored procedure in teradata?
What are the available primary index types in teradata.
Explain the term 'database' related to relational database management system?
If RDBMS is halted what will you do ?
Difference between stored procedure and macro?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What is logical data model?
Explain BYNET.
How do you see a ddl for an existing table?
