Re: Alter table (with large no. of data)

June Tong wrote: > > Sujit.Pal@alltel.com wrote: > > > You would need to increase the number of logical logs. The reason is > > that DDL statements such as ALTER are always logged regardless of > > whether your database is logged or not. > > Yes, that's true, but the ALTER statement by itself is not what's filling up the > logical logs; it's all the individual INSERT statements that result from the ALTER, > as the engine copies all the rows from the original table to the new table. These > would not be logged if the database had logging turned off. > Above situation was true for IDS up to 7.2X. From IDS 7.30 onwards Informix handles it in a different way, by altering table information and leaving the data virtually untouched. This avoids the creation of a new table and duplication of all the data, before dropping the original. So those using 7.30, have one less thing to worry. -- Have a nice day Felix K. Mathews mailto:fmathews@systems.dhl.com