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

"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.
> >
Received on Fri Feb 07 2003 - 16:53:16 CST