Explain The Concept Of Fragment Elimination In Informix ?

1.	Explain The Concept Of Fragment Elimination In Informix ?
Answer» Fragment elimination appears when the following conditions are all satisfied: A table is fragmented The FRAGMENTATION FORMULA doesn’t create overlapping ? asta oricum nu e PERMIS (overlapping) A query uses equality FILTER on a column used in the fragmentation formula If the above conditions are MET, the Informix engine can skip fragments (data is not searched there) that don’t comply with the query filter

Answer»

Fragment elimination appears when the following conditions are all satisfied:
A table is fragmented
The FRAGMENTATION FORMULA doesn’t create overlapping ? asta oricum nu e PERMIS (overlapping)
A query uses equality FILTER on a column used in the fragmentation formula
If the above conditions are MET, the Informix engine can skip fragments (data is not searched there) that don’t comply with the query filter

Discussion