Altering a Large Table
Posted in 2010
Laurie Gustin — — source: Usenet: comp.databases.informix
IDS 10.0 FC8
I'm wondering if there is a trick to altering a large table without running into a large transaction. I'm trying to add a char(2) field to the end of an existing table - it has 23 cols and about 12 million rows.
The total table size is about 2.5 GB, there is 4GB of logical logs.
I'm running the following alter command in dbaccess;
alter table address add add_source char(2);
Is there a trick to doing an in-place alter?
Thanks
Laurie
Laurie Gustin
IT Programmer Analyst
Department of Public Safety
lgustin@utah.gov
801-965-4410