From: Heiko Giesselmann (heiko.giesselmannwebwasher.com)
Date: Wed Oct 13 2004 - 09:25:17 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi,

with SQL server and Oracle some alter table statements will work very
fast even on large tables (e.g. 'alter table add column' with no default
values and allowing null values) while other alter table statements will
effectively copy table contents to accomplish the schema change (e.g.
'alter table add column' with some default value and NOT NULL clause).

Are there similiar differences in the behavior of alter table statements
for MaxDB? Is there a documentation on which statements can be executed
as pure DDL in contrast to the ones that result in an effective 'copy'
operation on a table?

Thanks, Heiko

------------------------------------------------------------------
This mail has been inspected by Webwasher - a CyberGuard Company -
leading technology for E-mail and Web Security.

Webwasher - keeping your Web clean!
------------------------------------------------------------------

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]