Re: Reversal of Records

Posted in 1991

Dave Snyder — Fri, 22 Nov 91 13:03:52 EST — source: Informix-list mailing list archive (1991-1998)

Quoting John Baker Depot Sys Mgt Br... > > I will try to conduct some experiments to see how Informix stores records > and get back with my results. From what I've experienced so far, when using > PERFORM and you do a Query (that is folks, you use the "Query" option on the > Perform menu), and then view your records using the "Next" option on the menu, > it seems to make no difference whether the table has a serial column or indexes > on various columns: after doing a series of deletes and adds, the newly added > records will not be retrieved in the order in which they were entered. > Create a clustered index on your SERIAL column... this works for me. DAS -- David A. Snyder @ Snide Inc. - Folcroft, PA Current Release is db4glgen-3.2 UUCP: ..!uunet!das13!dave INTERNET: Dave.Snyder@snide.com