Re: Hopeful No-brainer !!!

U wrote ---- If you select from a table (with or without indexes) and don't include an order by clause, what is the default order of the rows returned? Is this order affected by the presece or absence of indexes? In my experience , I found that the default order is the order of rowid in 7.1 version if the table is not fragmented. HTH ____________ Sanjay Kumar Email: skumar@raileurope.com Rail Europe Inc. 226 Westchester Ave | Office : (914) 681 3296 White Plains, NY 10604 | Fax : (914) 682 5236