Re: Hopeful No-brainer !!!

stiglich@interserv.com wrote: >> Spetc@aol.com writes: >> 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? >> >>>>> >If you don't have a clustered index, the data is stored in the order in which >it was inserted. However, custered indexes doesn't t keep the data ordered >continuously. >Pete This is not strictly correct. The rows are returned in physical order (ie rowid order). If rows are deleted, or a new extent is assigned that is at an earlier address than an existing extent, then the rows will not be returned in the order that they were inserted. Cheers, Brent Jackson. brent@advgroup.co.nz Phone : 64-9-3610613 Fax : 64-9-3764210