Re: Hopeful No-brainer !!!

Spetc@aol.com 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? 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 of indexes. I believe that version 7.x is the same unless the table is fragmented. Hope this helps. -- Stefanie Vario svario@zenacomp.com ZenaComp Incorporated http://www.zenacomp.com/~zenacomp