阅读背景:

同步表-更新插入删除的顺序重要吗?

来源:互联网 

I need to synchronize tables between 2 databases daily, the source is MSSQL 2008, the target is MSSQL 2005. If I use UPDATE, INSERT, and DELETE statements (i.e. UPDATE rows that changed, INSERT new rows, DELETE rows no longer present), will there be performance improvements if I perform the DELETE statement first? i.e. so that the UPDATE statement doesn't look at rows that don't need to be updated, because they will be deleted.I need to synchronize tables between 2 database




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: