触发器并不像参照完整性约束和检查约束那样,我们甚至可以使用对其他表来进行更新。
Triggers, unlike referential and check constraints, can even be used to update other tables.
推荐:为带有参照完整性约束的别名使用“noload”选项,并在复制管理工具外部装入目标表。
Recommendation: Use the "no load" option for nicknames with referential integrity constraints and load the target table outside of the replication administration tools.
同样,在执行装入操作期间,QApply程序也不删除别名上的参照完整性约束,并在这之后恢复它们。
Also, the Q Apply program does not drop referential integrity constraints on nicknames during the loading process and then restore them.
在ETL过程中,即时参照完整性和检查约束极其有助于检测数据问题,在最终的数据仓库表中实现它们也不会高效。
Even though referential integrity and check constraints are very helpful during the ETL process to help detect data problems, implementing them on final data warehouse tables is not efficient.
这一类的开销包括检查约束验证和外键约束(参照完整性(RI))验证。
This category of overhead includes CHECK constraint verification and foreign key constraint (referential integrity (ri)) verification.
这一类的开销包括检查约束验证和外键约束(参照完整性(RI))验证。
This category of overhead includes CHECK constraint verification and foreign key constraint (referential integrity (ri)) verification.
应用推荐