Interested to Buy Any Domain ? << Click Here >> for more details...
explain the concept of fragment elimination in informix ?
- 1 Answers
- 89 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / Jogendra
Fragment Elimination is a technique used by Informix to optimize queries with multiple joins and complex conditions. It works by first evaluating each table individually, then combining the results based on join conditions. If one table has fewer matching rows than another, the smaller table's results are eliminated (or 'eliminated as a fragment'), reducing the amount of data that needs to be joined. This speeds up query execution and decreases the load on the system.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
