|Subject||Re: FIRST 1 question|
--- In email@example.com, "Ann W. Harrison"
> russellbelding wrote:
> > The "Natural ordering" has been identified with the order a
> > records happen to be on disk, and if an "Order By" is missingfrom a
> > select statement then the select statement will act as if "orderby
> > Natural" was written, understanding there is no "natural"ordering
> > that can be used in a statement. Is this correct?unordered
> Not necessarily. The fact is that the order of rows in an
> statement is undefined. As an implementation artifact, rows arereturned
> in storage order, but that could change.and
> > The natural ordering of a table is affected only by insertions
> > deletions on the table. Is this correct?the
> Also updates.
> > It was suggested that immediately following a backup and restore
> > natural ordering is the primary key ordering. Is this correct?existing
> No. The backup/restore will (as an artifact) preserve the pre-
> order.Thanks Ann.