Re: Insert /* +append */ always ?

No.
The append hint does not generate redo log information. So the only time you should use it is when you can afford to loose the data in the table. Once your next hot or cold is taken than you off course are no longer at risk.

So if you are loading right before a backup the risk is minimal. The longer you wait the bigger the risk.

Also you need to be aware that when you use the append hint the data is inserted beginning at the high water mark of the table. So you have just deleted a bunch of data those blocks will not be reused. If the tables was just truncated than it will start loading at the beginning.

Hope this helps.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

Author of 'So You Want to be an Oracle DBA?'

"R Chin" <rchin_at_panix.com> wrote in message news:ab1l09$94b$1_at_reader1.panix.com...
> Should I ALWAYS do
> Insert /* +append */ into select .....
> as opposed to
> Insert into select...... ???
>
> Under what circumstances should I NOT use the hint ?
>
> Thanks
>
> Rob
>
>
>
Received on Sat May 04 2002 - 17:38:38 CDT