SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 04:05 PM
| ||||
| ||||
 RE: In-place alter table and boolean column This is a known issue and has been reported to IBM. j. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]On Behalf Of Danilo Fiorenzano Sent: Saturday, July 21, 2007 5:58 PM To: informix-list@iiug.org Subject: In-place alter table and boolean column Hello gentlemen, In running "ALTER TABLE bigtable ADD (yncolumn BOOLEAN)" on IDS 9.40 I found to my surprise that the server chose to execute the slow algorithm instead of the in-place alter I expected. Is this normal? The Performance Guide does not say anything special about boolean columns and "alter table", so I thought that the new column would be added in-place as it is of a built-in type, after all. thanks for your insight -- Danilo. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list      |
 |
« Final CALL FOR PAPER (Workshop on Workflow and Process Management, WfPM2007, in the framework of SYNASC 2007)
|
Lazy IDS Onbar Backup »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 08:02 PM.
