Re: Time consuming for drop column

From: Chirag <shahcm_at_yahoo.com>
Date: 10 Aug 2001 01:14:02 -0700
Message-ID: <732c49b9.0108100014.55eaa5e@posting.google.com>

Dear Choi,

It would be second option bcoz while updating column with null values means it won't carry space in the block. And after, then droping column is to make the things as permanent.

Chirag Shah
Oracle Administrator

"Konghun Choi" <ashydays_at_shinbiro.com> wrote in message news:<dYHc7.15375$2k2.709858_at_news.bora.net>...
> I have to drop column from table which have about 2,000,000 rows.
>
> Which is the less time consuming ?
> the one is just 'alter table <table> drop column ...'
> the other is 'update <table> set <column to drop> = NULL ,... '
> and after 'alter table <table> drop column ...'
>
> Thanks in advance.
Received on Fri Aug 10 2001 - 03:14:02 CDT