Why are recursive relationships bad? How do you resolve them?
- 1 Answers
- 669 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
