In-place alter table and boolean column
This is a discussion on In-place alter table and boolean column within the Informix forums, part of the Database Server Software category; --> Hello gentlemen, In running "ALTER TABLE bigtable ADD (yncolumn BOOLEAN)" on IDS 9.40 I found to my surprise that ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 05:05 PM
| ||||
| ||||
 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.      |
|
04-20-2008, 05:05 PM
| ||||
| ||||
| Re: In-place alter table and boolean column 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 |
Linear Mode
