Improved scan statistics accuracy.
改善了扫描统计信息的准确性。
The optimizer, in the absence of current statistics, is choosing to do a table scan on both tables involved in the join.
在缺少当前统计的情况下,优化器选择对参与联接的两个表进行表扫描。
This avoids another scan of the index in order to gather statistics. The following examples illustrate some of the options available to do this.
这将避免为了收集统计信息而进行的另一项索引扫描。
应用推荐