 |
 |
Archives of the TeradataForum
Message Posted: Thu, 28 Feb 2008 @ 18:02:39 GMT
| Subj: | | Re: Impacts of adding column to a large table |
| |
| From: | | Dieter Noeth |
Longauer Juraj wrote:
| | I have a large table (~150 GB) on which I want to add a nullable column using ALTER TABLE command. I am curious how big is the impact on
the system performance and availibility of the table duration of the lock, adding NULL to each record etc. | |
If you add that column using COMPRESS NULL and there're still unused bits available within the presence bytes, this will run immediately
without modifying any row.
Dieter
| |
