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

Ah! The joys of the English language -

I didn't manage to express exactly what
I wanted to - and it's my native language.

I was addressing your comment about the

    "APPEND hint no redo/no undo "

to make the point that the APPEND hint does not have a "no redo / no undo" feature. The APPEND hint merely has a 'put is above the HWM' feature that is equivalent to just a "no undo" feature which applies only for the table blocks. Then, if you ALSO make the table NOLOGGING, you bring in a totally separate feature which in this case has the added benefit of eliminating redo for the table blocks.

APPEND has an effect whether or not the table is NOLOGGING.

--
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.0302071453.1b5b5856_at_posting.google.com>...
>"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
news:<b20s1l$517$1$8302bc10_at_news.demon.co.uk>...


>> 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.

>>

>   Jonathan,  shouldn't it be (NOLOGGING + APPEND) stops REDO being
>generated for the table blocks ? I am talking about insert
operations,
>not table creation.
>
>   Igor.
>


>> --

>> 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.

>> >