Re: ROWID Question

Posted in 1996

Bill Ennis — 8 Nov 1996 10:43:25 -0500 — source: Informix-list mailing list archive (1991-1998)

I'd be careful with this. With the introduction of fragmentation you can no longer assume much about the integrity of rowids. You should probably create a serial column in the table and this will serve your purpose. -Bill > > In 7.2 DS, if I have a table in which I NEVER delete records, will the > ROWIDs be added sequentially? We have notes tables which need to be > retrieved in formcode in the order they were entered. > > Tim > -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com