alter table in-place algorithm

Posted in 2007

mohitanchlia@gmail.com — Sat, 28 Jul 2007 16:20:47 -0000 — source: Usenet: comp.databases.informix

Is there a way to tell informix to use in-place algorithm for alter table modify column. I have to modify column of table that has 50 M rows. These columns are of type varchar. I think by default informix is using slow algorithm

↪ replying to mohitanchlia@gmail.com

Jack Parker — Sat, 28 Jul 2007 12:35:39 -0400 — source: Usenet: comp.databases.informix

Does the table have a user defined datatype in it? (This includes Boolean). j. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]On Behalf Of mohitanchlia@gmail.com Sent: Saturday, July 28, 2007 12:21 PM To: informix-list@iiug.org Subject: alter table in-place algorithm Is there a way to tell informix to use in-place algorithm for alter table modify column. I have to modify column of table that has 50 M rows. These columns are of type varchar. I think by default informix is using slow algorithm _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list