Re: [Q] fragmentation and rowids

May be some guru can tell us who is right :-) I think we both are. The assumptions are simply different. Of course David's comments on rowid's are right, but ISQL can only be changed in this respect by Informix. Newer ever use rowid's again if you have ever before fallen in that trap. Also don't break any other of the rules of proper relational database design. Sooner or later it will fire back on you very hard. Often sooner. "DavidCoburn/ISG/WVUS/WorldVision"@wvus.org ("David Coburn/ISG/WVUS/WorldVision@WVUS") wrote: : : Well, Richard, I would be happy to tell you that you're wrong, except : that you aren't. This is the way things work starting with that release : of OnLine. This was documented some time ago as being a natural result : of fragmentation. Besides, rowids are hardly relational; if you are : using them, you have been running a risk for some time now of a broken : application. : : David Nils.Myklebust@idg.no (Nils Myklebust) wrote: :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. : >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!!! : > : >Richard. 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