Re: would nologging work on alter table add primary key ?

Ted Chyn wrote:

> create index .. nologging can reduce the amount of redo generation.
> Is this true for ' alter table add constraint primary key ( ) using
> index tablespace '
>
> I did a test on this and found there is no reduction in redo generation when
> using 'alter table add constraint primary key' to create primary key index.
>
> my question:
>
> 1. Is my observation correct ?
> 2. If so why the difference ?
>
> thanks ted

Reduces overhead creating the index. What were you expecting? On every insert, update, and delete thereafter?

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)