Alter Table in 9.4.FC8

Posted in 2006

Topics: Data Types & Schema Design, Internationalization & Character Sets

Colin Dawson — Wed, 28 Jun 2006 12:56:22 +0000 — source: Usenet: comp.databases.informix

We have an ALTER TABLE statement that will change VARCHAR(30,0) to VARCHAR(80,0), The table has 99M rows. When running a test it looks like it is altering every row, will it do this instead of the expected quick alter because we are changing the length of a varchar? Regards Colin There are 10 types of people in the world, those that understand binary and those that don't _________________________________________________________________ Windows Live' Messenger has arrived. Click here to download it for free! http://imagine-msn.com/messenger/launch80/?locale=en-gb

↪ replying to Colin Dawson

TBP — Wed, 28 Jun 2006 13:07:41 GMT — source: Usenet: comp.databases.informix

Colin Dawson wrote: > We have an ALTER TABLE statement that will change VARCHAR(30,0) to > VARCHAR(80,0), The table has 99M rows. When running a test it looks like > it is altering every row, will it do this instead of the expected quick > alter because we are changing the length of a varchar? > > > > Regards > > Colin > > There are 10 types of people in the world, those that understand binary > and those that don't > > _________________________________________________________________ > Windows Live' Messenger has arrived. Click here to download it for free! > http://imagine-msn.com/messenger/launch80/?locale=en-gb > What is the rest of the schema? ================================= Important: When a table contains a user-defined data type or smart large objects, the database server does not use the in-place alter algorithm even when the column being altered contains a built-in data type. ================================= Although there is no explicit mention of increasing a varchar length.