As described in the problem statement, it is the goal of this approach to avoid data redundancy when providing an integrated view over heterogeneous sources.
正如问题说明中所述,此方法的目标是避免提供异类源的集成视图时出现数据冗余。
The naive approach USES a cursor to scan the table and execute a positioned update statement for each row.
初级的方法是使用一个游标对表进行扫描,并为每一行执行一个定位的更新语句。
The first approach took 0.050 seconds in total, whereas the combined statement could be completed in 0.012 seconds.
第一种方法总共花费0.050秒,而组合语句可以在0.012秒内完成。
应用推荐