Re: Hopeful No-brainer !!!

> mickey.mestel@etak.com (Mickey Mestel) writes: > > 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 Wrong. Remember it's a relational database. There is no order without an order by. Se my other post from yesterday on why this *is* wrong in many cases. In OnLine this may be wrong even if you never delete any rows. (On SE my experience is that it is right as long as you do not delete any rows, do not get an index scan for some reason or ?? or ?? or.....). Nils.Myklebust@ccmail.telemax.no NM Data AS, Postbox 9090, Gronland, 0133 Oslo, Norway My opinions are those of my company