Re: Append hint

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Sat, 26 May 2001 02:43:35 GMT
Message-ID: <3b0f1579.4539334@news-server>

On Fri, 25 May 2001 19:41:34 +0100, "Alan" <alan_at_NOSPAM.opcomp.demon.co.uk> wrote:

>
>All things being equal, I would assume that if you have to insert records
>(say 1M+) into a large table (say 100M+) and the table has indexes, then the
>sensible way would be to use APPEND/PARALLEL hints and to leave indexes
>enabled.
>

Not exactly. APPEND is the way of telling the INSERT to use a direct data load. As SQL*Loader does. Ie, you get blocks loaded in bulk, rather than row-by-row.

To do this, the RDBMS has to disable indexes because there is no way the bulk load will work on indexes. And if indexes are enabled, every row loaded will cause an index insertion, defeating the purpose of the bulk load.

AFAIK, there is no way of using APPEND and leave indexes enabled. The APPEND will only work if they are disabled, although you may have added it to the statement.

Anybody else has found a way?

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Fri May 25 2001 - 21:43:35 CDT