Re: internal order of oracle tables
Date: 11 Jul 1994 22:08:01 -0600
Message-ID: <2vt4v1$nts_at_tibalt.supernet.ab.ca>
Robert J. McCallister (rjmac_at_crl.com) wrote:
> Sure there is a way to have all the records in a table sorted by the primary
> key, it is not very easy but try this:
> Print out all your records, get a bunch of file folders, label each
> folder with the primary key, place the record in each folder, place the
> folders in the file cabinet in order by the primary key. That is pretty
> simple right? Does what you want right? Takes to much time right?
> Alternative:
> Let Oracle do the work for you, what difference does it make what order
> the records are in the table, to get them out in the proper order all you
> have to use is an order by clause in the select statement, if you want
^^^^^^^^^^^^^^^^^^^^^^^
By definition of SQL and 'relational'
model, you must always supply an order by
clause - the model guarantees that there
is no guarantee to the order internally stored.<g>
/Hans Received on Tue Jul 12 1994 - 06:08:01 CEST