Loading a database from a previous dump causes any triggers defined in the database to fire, which can increase the amount of time required to load the database. Adaptive Server 12 introduces the disable trigger option of the alter table command to disable any triggers in a database before you load the database, reducing the time required to load the database. Use alter table... enable trigger to re-enable the triggers after the load database is complete. alter table... disable trigger uses the following syntax:
alter table [database_name.[owner_name].]table_name
{enable | disable} trigger [trigger_name]
