Oninit cdi / Archive
Talk to an expert →

Are rowids always in increasing order?

Posted in 2004

Topics: General Discussion

Jean Sagi — — source: Usenet: comp.databases.informix

Hi, I wonder if anyone one knows if IDS (9.3) asigns rowids in increasing order? I mean Always. In the documentation it i stated that: "The database server assigns to each row in the rowid column a unique number that remains stable for the life of the row." But I haven't found any indication that the numbers asigned to the rowdis are always choosed in increasing order. If anyone know, let me know . I'll appreciate it a lot. Chucho! Jean Sagi jeansagi@myrealbox.com jeansagi@netscape.net sending to informix-list

↪ replying to Jean Sagi
Fernando Nunes — — source: Usenet: comp.databases.informix

Jean Sagi wrote: > Hi, > > I wonder if anyone one knows if IDS (9.3) asigns rowids in increasing order? > > I mean Always. Short answer: NO! Forget about it. Regards.

↪ replying to Jean Sagi
Madison Pruet — — source: Usenet: comp.databases.informix

No. Where in the documentation does it say that? "Jean Sagi" <jeansagi@myrealbox.com> wrote in message news:c69l83$lfr$1@terabinaries.xmission.com... > > Hi, > > I wonder if anyone one knows if IDS (9.3) asigns rowids in increasing order? > > I mean Always. > > In the documentation it i stated that: > > "The database server assigns to each row in the rowid column a unique number that remains stable for the life of the row." > > But I haven't found any indication that the numbers asigned to the rowdis are always choosed in increasing order. > > If anyone know, let me know . I'll appreciate it a lot. > > > Chucho! > > > > Jean Sagi > jeansagi@myrealbox.com > jeansagi@netscape.net > > > sending to informix-list

Glossary