Append hint

From: Alan <alan_at_NOSPAM.opcomp.demon.co.uk>
Date: Fri, 25 May 2001 19:41:34 +0100
Message-ID: <990816328.28778.0.nnrp-12.9e985e86@news.demon.co.uk>

I've seen it documented on this group that the use of an APPEND hint on an insert forces Oracle to rebuild indexes, and I'd just like to clarify what that means.

If I have a large indexed table and insert a relatively small number of records, the time to insert the records using the APPEND hint is not proportional to the time it would take to rebuild the indexes (it is much faster), so I would, therefore, presume that Oracle is not completely rebuilding the indexes.

I also notice that some developers disable indexes if they are going to insert (with or without APPEND) a large number of records into a table and then rebuild indexes afterwards.

Is there any value to this (with APPEND), if Oracle is managing (full rebuild) the indexes for you.

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.

Alan Received on Fri May 25 2001 - 13:41:34 CDT