Answer / 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.

what rules exist regarding format, content, flame wars, etc

1 Answers   IBM,

---

what is the size of informix page?

1 Answers   IBM,

---

what can be used to capture an isam error from an informix odbc program on unix?

1 Answers   IBM,

---

what is informix universal server?

1 Answers   IBM,

---

who conceived and designed the informix database management system?

1 Answers   IBM,

---

What is a database object in ibm informix?

1 Answers  

---

List down the features of informix 4gl.

1 Answers  

---

what are the informix isolation levels and can you explain each one ?

1 Answers   IBM,

---

why do foreground writes decrease performance ?

1 Answers   IBM,

---

what is a binary large object ?

1 Answers   IBM,

---

why a foreground write in informix decrease performance?state the reason for the same?

1 Answers   IBM,

---

what is informix binary large object?

1 Answers   IBM,

---