In this example, we'll see how the plan changes when the statistics are not updated properly.
本例中,我们将看到没有正确更新统计数据时计划是如何变化的。
There is an attribute RUNSTATS TIMESTAMP on the table or index node of the access plan graph that indicates the last time when the statistics were collected.
在访问计划图的表或索引节点上会有一个RUNSTATSTIMESTAMP属性,它表示收集统计数据的时间。
There is an attribute RUNSTATS TIMESTAMP on the table or index node of the access plan graph that indicates the last time when the statistics were collected.
在访问计划图的表或索引节点上会有一个RUNSTATSTIMESTAMP属性,它表示收集统计数据的时间。
应用推荐