Execute statistics advisor to improve statistics quality and collection.
执行统计数据advisor工具以改善统计数据和收集。
Run the statistics advisor and take actions to make statistics current.
运行统计数据advisor 工具，并采取行动更新统计数据。
Statistics advisor: recommendations for collecting the required statistics to facilitate access path selection.
统计数据advisor工具：收集所需统计数据以完成访问路径的建议。
The statistics advisor also assesses the relative importance of the advice and gives the following two types of recommendations.
统计数据advisor还会评估建议的相对重要性，并给出如下两种类型建议。
In other words, the statistics advisor can help improve statistics quality as well as improve the efficiency of statistics data collection.
换句话说，统计数据advisor工具能帮助提高统计数据质量并提高统计数据收集效率。
The statistics Advisor will let you know when it's time to update those catalog statistics and generate the command to do so-all you have to do is click a button.
Statistics Advisor会指出什么时候应该更新编目统计数据并生成所需的命令；您只需单击一个按钮即可。
Query Tuner statistics advisor makes it easier by providing RUNSTATS recommendation to collect the required statistics by identifying the following problematic statistics status.
QueryTuner统计数据通过提供RUNSTATS建议使得确定以下问题统计状态，收集所需统计数据变得非常容易。
As you drill into the advice for a specific recommendation, as shown in Figure 15, you'll see that the statistics advisor generates a RUNSTATS command that you can use to collect or repair statistics.
当您深入研究某个具体建议，如图15所示，您会发现统计数据advisor工具生成一个RUNSTATS命令，您可以用它来收集或修复统计数据。
The output file generated by the Design Advisor contains a set of DDL statements that create MQTs, refresh and update statistics on the MQTs, and create indexes on them.
Design Advisor生成的输出文件包含一组ddl语句，用于创建MQT、刷新和更新MQT上的统计信息，以及在其上创建索引。
The option -r instructs the Design Advisor to use extended statistics for the considered MQTs.
选项-r指示Design Advisor为考虑的 MQT使用扩展的统计信息。
Accurate and complete statistics will help drive good access path advice, and of course the index advisor should not be executed without good statistics.
准确而全面的统计数据能帮助生成良好的访问路径建议，当然，索引advisor工具执行时要有准确的统计数据。
In Figure 15, you can see that the advisor found several instances of conflicting or missing statistics as well as providing the explanation about why the advisor thinks they are conflicting.
在图15中，您看到advisor工具找到几个冲突或丢失的实例，并提供了为什么advisor工具认为其冲突的解释。
As the UIS Asia-Pacific Regional Advisor and Head of the Assessment, Information Systems, Monitoring and Statistics (AIMS) Unit of the UNESCO Asia-Pacific Regional Bureau for Education, Mr.
西蒙·艾里斯是UIS亚太地区责任顾问，同时主管联合国教科文组织亚太局教育部的评估、信息系统、监测和统计。
As the UIS Asia-Pacific Regional Advisor and Head of the Assessment, Information Systems, Monitoring and Statistics (AIMS) Unit of the UNESCO Asia-Pacific Regional Bureau for Education, Mr.
西蒙·艾里斯是UIS亚太地区责任顾问，同时主管联合国教科文组织亚太局教育部的评估、信息系统、监测和统计。
应用推荐