Oninit cdi / Archive
Talk to an expert →

In-place alter table and boolean column

Posted in 2007

Topics: Performance & Tuning, Versions, Editions & End-of-Life

Danilo Fiorenzano — — source: Usenet: comp.databases.informix

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.

↪ replying to Danilo Fiorenzano
Carsten Haese — — source: Usenet: comp.databases.informix

On Sat, 2007-07-21 at 21:57 +0000, Danilo Fiorenzano wrote: > 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. boolean is a user-defined type. You didn't define it, the system did, but it's still in sysxtdtypes. Adding a UDT column uses slow alter. HTH, -- Carsten Haese http://informixdb.sourceforge.net

↪ replying to Danilo Fiorenzano
Jack Parker — — source: Usenet: comp.databases.informix

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

Glossary