RE: alter table in-place algorithm

Then I have no clue. Sounds like it should be using an in place alter. j. -----Original Message----- From: Mohit Anchlia [mailto:mohitanchlia@gmail.com] Sent: Saturday, July 28, 2007 11:59 PM To: Jack Parker; informix-list@iiug.org Subject: Re: alter table in-place algorithm No it doesn't. It has Integer, Varchar, char and serial number, smallint. I am trying to modify column which are varchar. I read on ibm site that informix doesn't use in-place algorithm if it's modification to varchar columns. Is there any way to explicitly tell informix to use in-place algorithm ? I've already run out of logs on this table ..It would be good if I can use this algorithm On 7/28/07, Jack Parker <jack.parker4@verizon.net> wrote: 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