The following warning replaces the warning currently in “Using table and column constraints” in Chapter 9, Ensuring Data Integrity,” in the Sybase IQ System Administration Guide.
WARNING! Altering or creating global or base tables can interfere with other users of the database. For large tables, ALTER or CREATE TABLE can be a time-consuming operation. CREATE TABLE processing delays execution of other IQ processes until the statement completes. Although you can execute ALTER TABLE statements while other connections are active, you cannot execute them while any other connection uses the table to be altered. ALTER TABLE processing excludes other requests referencing the table being offered while the statement processes.