Re: what's the impact of this

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Fri, 24 Aug 2001 05:05:03 GMT
Message-ID: <3glh7.439328$p33.8490287@news1.sttls1.wa.home.com>

If you had added the not null condition then it would have to turn all nulls to 'N', but it shouldn't have much of a performance impact if any. Jim
"blah" <blah_at_blah.com> wrote in message
news:9m4m0s$8uc1_at_inetbws1.citec.com.au...
> Hi All,
>
> Could someone discribe the possible impact/impacts of running this sql
against
> a busy production database.
>
> alter table customer
> add(deleted varchar2(1) default 'N');
>
> Thanks,
> Chris
>
Received on Fri Aug 24 2001 - 00:05:03 CDT