Re: [Q] fragmentation and rowids

richardt@TheMusicStore.co.uk (Richard Thomas) wrote: :So what you're saying is that an application using ISQL forms will :work perfectly OK following an upgrade (as it did at my last place :of employment when we upgraded from 5.0.3 to 7.13/ISQL 4 to 6), :but if 'the powers that be' decided to fragment tables, EVERY table would :have to be rebuilt with rowids before ANY ISQL form would work. : :Jeez! : :(This would be an issue - c.50 databases of varying sizes, all using PERFORM :as the front end). : :Please tell me I'm wrong!!! Yes you are wrong. Fragmentation is on a per table basis. You wouldn't fragment every table in every database. The non fragmented tables have rowid without having to add it (if my memory doesn't fail me completly this late at night). Also if you do decide to fragment a lot of tables you have quite some work to do (setting up the fragmentation spesification for all the tables). The overhead of also adding the rowid may not be that large. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org