Re: insert as select

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 26 Apr 1999 21:29:29 +0100
Message-ID: <925158921.21545.0.nnrp-02.9e984b29@news.demon.co.uk>

The point of inserting an order set of data is that an index on the ordered columns will have a very low clustering factor, and queries against that set of columns will perform very efficiently.

The syntax is nominally not supported

until Oracle 8.1.  Strangely, though,
it may work on 7.3.4 - see my website -
as some of the 8.1 code seems to have

slipped back (missing 8.0) into 7.3.4

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

smiths_at_logica.com wrote in message <3724BC9C.E1BED807_at_logica.com>...
>What do you have to gain be ordering your inserts?
>
>Ysteric's wrote:
>
>> Ii there anybody to tell me why :
>>
>> insert into rubriques
>> select r1.code c, r1.code_mere, r1.niveau, 0, 0, r1.libelle
>> from rubr r1
>> order by c
>>
>> does not work, but :
>> insert into rubriques
>> select r1.code c, r1.code_mere, r1.niveau, 0, 0, r1.libelle
>> from rubr r1
>>
>> works quit well !!!
>>
>> whats wrong with the "order by" clause
Received on Mon Apr 26 1999 - 15:29:29 CDT