使用负载管理检查事实构建表对象同步选项卡,使用以“_ MEASURES”结束的名称定位它们,并标记名称和状态。
Using load management check the synchronization TAB for the fact build table objects, locate those with names ending with "_measures" and note the name and status.
DB 2依据时态表的开始和结束列中使用的数据类型,使用合适的where子句谓词自动重写查询。
DB2 automatically rewrites the queries with appropriate WHERE clause predicates depending on the data types used in the start and end columns of the temporal tables.
DB 2将历史表中所删除行的结束时间设置为与delete语句的最新事务相关联的开始时间。
DB2 sets the end time of the deleted row in the history table to the start time that is associated with the most recent transaction of the delete statement.
Let's check it out. I've written a little bit of a test script here, so if we test cell sort, and I've written this so that it's going to print out what the list is at the end of each round, OK.
我们来检查检查,我写了一个小测试脚本,我写这个脚本来测试单元排序,它能够打印出每一轮结束后,链表的是什么样子的。
应用推荐