Re: ALTER TABLE ADD columns in parallel?

From: Rich Jesse <>
Date: Wed, 5 Mar 2014 11:04:37 -0600 (CST)
Message-ID: <>

Mark replies:

> Try this instead:
> Alter table erptbl add (newcol1 nchar(1) default ΠΠnot null);
> I think youčll find that if you add the ŒNOT NULLč, it becomes DDL only
> operation, and completes w/ sub second response.

Perhaps, but a NOT NULL constraint and DEFAULT value are very different. The NOT NULL will error out when violated whereas the DEFAULT value will just fill in the gap.

And I'm not able to modify the SQL...

Thanks for the feedback!


Received on Wed Mar 05 2014 - 18:04:37 CET

Original text of this message