Re: Change varchar column

Posted in 2003

Scott MacKenzie — Wed, 17 Dec 2003 12:39:04 -0700 — source: Usenet: comp.databases.informix

Have you checked your FILLFACTOR? Bernstein, Rick wrote: > 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? > -- ( ______ )) .-- Scott MacKenzie; Dine' College ISD --. >===<--. C|~~| (>--- Phone/Voice Mail: 928-724-6639 ---<) | ; o |-' | | \\--- Senior DBA/CARS Coordinator/Etc. --/ | _ | `--' `-- E: scottm at dinecollege dot edu -' `-----' sending to informix-list