RE: Change varchar column

Posted in 2003

Bernstein, Rick — Wed, 17 Dec 2003 10:56:37 -0800 — source: Usenet: comp.databases.informix

Are indexes built on this changed column? Each occurrence of this changed column in an index will now consume 256 bytes instead of 11 bytes. Rick -----Original Message----- From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] Sent: Wednesday, December 17, 2003 9:28 AM To: informix-list@iiug.org Subject: Re: Change varchar column Mark wrote: > Dear all, > > During a table schema migration task, I unloaded data from a table, drop > the table and re-create the table with changed some column from > varchar(10) to varchar(255), then re-load the original data back to the > new table. > > We found space used increased from 1GB to 1.5GB for that table. > > Anyone know why. It's hard to tell from this angle. Perhaps there is a different minimum size to the column or something? -- "C'est pas parce qu'on n'a rien a dire qu'il faut fermer sa gueule" - Coluche sending to informix-list