Dropping a column

Posted in 2007

Colin Dawson — Tue, 06 Mar 2007 14:29:39 +0000 — source: Usenet: comp.databases.informix

When you do ALTER TABLE xxxx DROP col1; does it do an inplacealter or will it sequentailly access every row physically removing the column. I always thought it physically removed the column, but having a scan through the docs I can't find any reference on how it actually does it. Regards Colin There are 10 types of people in the world, those that understand binary and those that don't _________________________________________________________________ Get Hotmail, News, Sport and Entertainment from MSN on your mobile. http://www.msn.txt4content.com/

↪ replying to Colin Dawson

david@smooth1.co.uk — 6 Mar 2007 16:40:34 -0800 — source: Usenet: comp.databases.informix

On 6 Mar, 14:29, "Colin Dawson" <cjd_1...@hotmail.com> wrote: > When you do ALTER TABLE xxxx DROP col1; does it do an inplacealter or will > it sequentailly access every row physically removing the column. I always > thought it physically removed the column, but having a scan through the docs > I can't find any reference on how it actually does it. > > Regards > > Colin > > There are 10 types of people in the world, those that understand binary and > those that don't > > _________________________________________________________________ > Get Hotmail, News, Sport and Entertainment from MSN on your mobile. http://www.msn.txt4content.com/ Which IDS version? Search here for IDS 10 - http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.perf.doc/perf194.htm