DB 2优化器使用目录统计信息来确定最佳的访问路径,而更新这些目录统计信息所采用的主要方法就是运行RUNSTATS实用程序。
The DB2 optimizer USES catalog statistics to determine the best access path, and the main method employed to update these catalog statistics is to run the RUNSTATS utility.
但是,现在缺乏关于这些方法实际工作的证据-因此在哪一条路径是最佳途径上没有达成共识。
There is, however, a shortage of evidence regarding which approaches will actually work - and therefore no consensus on which path is best to follow.
实现此目标的最佳方法是,找到给定站点与稳定的可理解的站点之间的最短路径。
The best way to do that is to find the shortest path between the site you are given and one that is stable and understandable.
应用推荐