Re: Rowid range in Informix 7.x

Michal Hajek wrote: > > David Kosenko wrote: > > > > Do note that if you are trying to use real rowids, and your table is fragmented, > > the rowids will NOT be guaranteed unique, and you CAN have multiple rows with > > the same rowid (albeit in different fragments). > > Excuse me, I seem not to understand well the term "fragmented > tables". Do you mean tables with more extents ? Or it is > something, which came with versions > 5.xx ?? > > This is important thing, we use programs, which use rowids > very often (OnLine 5.02). > This type of table fragmentation does not refer to large numbers of extents, but data / index placement. Starting with 7.x, Informix allows you to detach indices, placing them in a different dbspace from the data if you wish. You can also spread the data between dbspaces using a rule-based distribution or a round-robin distribution. It allows I/O to be spread out over disks in a controlled manner, as opposed to a single disk getting hammered because of one table accessed repeatedly Not too bad. Just fragging a table, a rather large one, has trimmed 20-25% off of our fiscal period close procedure and speeded up the reports as a result. John Carlson Informix DBA WH Smith, Inc.