Re: Time consuming for drop column

Both of these methods will be much slower than setting the column unsued

example
 alter table foo set unused column a
 /

Table altered.

The column is simply marked as unused in the DD so regardless of table si ze,
the operation finishes immediately.                                                                       

Get free email and a permanent address at http://www.amexmail.com/?A

-- 
Posted from awcst094.netaddress.usa.net [204.68.24.94] 
via Mailgate.ORG Server - http://www.Mailgate.ORG