Re: OnLine 7.12: Fragment Elimination Problem

David Williams (djw@smooth1.demon.co.uk) writes: I believe that Informix does not do fragment elimination when it uses an index - all it has to do is use the index to get to the data - fragmnent elimination only occurs when indicies are not used. The idea is that if you have to scan the table for data you can scan only one fragment if you know the data can only exist in one fragment. Aso when data is inserted you can force the insertion to occur into one fragment so if the data row ( or index for fragmented indicies) has to be read from the disk you can force the disk I/O to occur from a particular disk i.e. balance disk I/O across disks by better controlling the layout of data/indicies. Can anyone confirm this? ----------------- Thanks for your response, and the behavior for indexed tables makes some sense, HOWEVER... The problem I desribed occurs even when the fragmented table has NO indices. Here we fully expect and require fragment elimination. ...Terry.