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

jonathan_at_jlcomp.demon.co.uk (Jonathan Lewis ) wrote: [snip]>
>'tuples' are logical, rows are physical.

I don't think this helps. Tomm's point is still valid.

>
>It may be very sensible for performance reasons to arrange the rows
>in a specific physical order.
>

So be it. But semantics aside, you cannot force Oracle to physically order data and maintain the ordering automatically(like you could in Sybase with a clustered index). You can do something like this with ORACLE8 using index-organized tables.

Cheers,

-- 
                      \\///
                      (0-0)
           +----oOO----(_)-----------+
           |       K. E. Fein        |
           |    Database Analyst     |
           |   kfein_at_primenet.com    |
           +------------------oOO----+