Re: Hopeful No-brainer !!!

Mickey Mestel (mickey.mestel@etak.com) 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? True only if no rows have ever been deleted and no indexes have been dropped (either of which would result in pages being re-used and rowid's no longer being consistently increasing), and no other table-rebuilding has been done. And rows are only returned in rowid order if a sequential scan is done: ie, there are no filters which can use an index and the columns selected are not all in an index (key-only scan). June ---- June Tong Informix Software ---- ---- Senior Consultant (415) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: San Jose, CA ----