Re: Hopeful No-brainer !!!

Mickey Mestel wrote: > > > The default is to return rows in rowid order in the absence of an order by > > clause in versions 5.x. The order is not affected by the presence or absence > > this means the order in which the rows were inserted, correct? > > mickm One question: let say that I delete a row and then insert another one, doesn't informix use the "new" available space. If it does, then it won't be in the order the rows were inserted, but be row id.