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

Hi!

Either use nologging when specifying PK index creation parameters or precreate index w. nologging and enable PK constraint afterwards.

Example syntax:

alter table t add constraint c primary key (a) using index storage (initial 10k) tablespace ts2k nologging;

Tanel.

"Ted Chyn" <tedchyn_at_yahoo.com> wrote in message news:44a19320.0307171337.1fe30685_at_posting.google.com...
> 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 Fri Jul 18 2003 - 11:10:22 CDT