Explain the concept of fragment elimination in Informix?

Questions by sripri   answers by sripri

Showing Answers 1 - 3 of 3 Answers

In certain circumstances, Informix can eliminate fragments from a search. When this occurs, system resources such as CPU cycles, cache buffers, and LRU queues are freed for other operations. Whether fragment elimination can occur depends on the form of the query and the distribution scheme of the table being searched. In brief, this can happen when the query is equality-based and uses filters on the same columns as those that define the fragmentation scheme.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions