Why are recursive relationships bad? How do you resolve them?
- 1 Answers
- 670 Views
- I also Faced
- E-Mail Answers
Answer / Jitendra Singh Jung
Recursive relationships, where a table references itself directly or indirectly, can lead to inefficiencies and performance issues due to the increased complexity of join operations. To avoid this:
1. Consider normalizing the data schema by splitting the recursive relationship into separate tables.
2. If the recursive relationship is necessary for business reasons, use advanced query optimizations such as recursive common table expressions (CTEs) or materialized views.
| Is This Answer Correct ? | 0 Yes | 0 No |
How do I become a database administrator?
What is an artificial (derived) primary key?
Which dba certification is best?
If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
What is the difference between truncate and delete? Why is one faster?
What is the difference between truncate and delete? How would a full table scan behave after?
What causes the "snapshot too old" error? How can this be prevented or mitigated?
What is the relation between database and instance?
What is pct free/pct used/pct increase parameter in segment?
How much money does a dba make?
How does one coalesce free space?
When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
Oracle General 
