Additionally, the consecutive INSERT operations would potentially be slower because the DB2 UDB engine would try to reuse the deleted records first.
此外,后续的INSERT操作也慢得多,因为DB 2udb引擎会首先尝试重用已删除的记录。
Upon arrival, a customer-written program adds the records to a staging table then USES insert statements to add the records to the fact table.
当该文件到来时,用户编写的一个程序将这些记录添加到一个staging表中,然后使用insert语句将这些记录添加到事实表中。
If you need more records, this INSERT statement can be repeated as many times as needed. You may also use a CROSS JOIN to get more records per statement, like this.
如果您需要更多记录,就可以根据需要多次重复执行这条insert语句。
If you need more records, this INSERT statement can be repeated as many times as needed. You may also use a CROSS JOIN to get more records per statement, like this.
如果您需要更多记录,就可以根据需要多次重复执行这条insert语句。
应用推荐