would nologging work on alter table add primary key ?

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 Received on Thu Jul 17 2003 - 16:37:28 CDT