Re: Should I use an /*+ append */ hint here???

For the sake of precision:

APPEND stops the UNDO being generated
for the table blocks.

NOLOGGING stops the REDO being generate
for the table blocks.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

____UK_______March 19th
____USA_(FL)_May 2nd


Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA_(CA, TX)_August


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


Igor Izvekov wrote in message
<9f17469e.0302070910.397107df_at_posting.google.com>...


>

> You can also turn logging off and on even after table creation (it

is


>Oracle 8i, right ?). Use "alter table table_name nologging" . And

yes,


>you want your table in nologging mode in order to take advantage of

>APPEND hint no redo/no undo feature.

>