Re: Insert from another table...Create with ORDER BY

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: 1997/08/15
Message-ID: <01bca9ad$9f854940$294b989e@WORKSTATION>#1/1

Tomm Carr <tommcatt_at_geocities.com> wrote in article <33F481A3.2A68_at_geocities.com>...
> eberry_at_dstcorp.com wrote:
> Oracle is a *relational* dbms, and remember one of the
characteristics
> of a relational database is the ordering of the tuples is not
> significant. Oracle does not allow the ORDER BY in the insert
statement
> because it is meaningless. If you will be accessing the data
ordered by
> -- apparently -- col1, then create an index on col1.

'tuples' are logical, rows are physical.

It may be very sensible for performance reasons to arrange the rows in a specific physical order. Received on Fri Aug 15 1997 - 00:00:00 CDT