Implementation architecture of advanced query statistics.
高级查询统计的实现架构。
Advantages of advanced query statistics in the new version.
新版本中高级查询统计的优势。
Figure 1 displays the advanced query statistics configuration screen.
图1显示的是高级查询统计配置界面。
Figure 3 shows the basic implementation architecture of advanced query statistics.
图3显示的是高级查询统计的基本实现架构。
In this section, let's walk through the steps to set up advanced query statistics.
本小节中，我们体验一下安装高级查询统计的步骤。
There are two steps or functions involved in working with advanced query statistics.
使用高级查询统计有两个步骤，或者说是两个功能。
The implementation of advanced query statistics is based on the query log database technology.
高级查询统计的实现是基于查询日志数据库技术。
Advanced query statistics is a new feature added to OmniFind Enterprise Edition in Version 9.1.
高级查询统计是OmniFindEnterpriseEdition在9.1版本中新加入的特性。
The first step is to configure this feature using the advanced query statistics user interface menu.
第一步是使用高级查询统计用户接口菜单配置该新特性。
There are three kinds of charts that are supported by advanced query statistics (reference Figure 2)
高级查询统计支持三种图表（参考图2）
Advanced query statistics has its own graphical user interface for visually displaying the information.
高级查询统计有自己的图形用户接口，用于可视化显示信息。
You can also change how query statistics are calculated by editing the runtime-generic.properties file for the search server.
还可以通过编辑搜索服务器的runtime - generic . properties文件改变查询统计数据计算方式。
When the query statistics widget shows statistics information, it accesses the ESAdmin web application from the user's client browser through an AJAX request.
当查询统计widget显示统计信息，它通过AJAX请求从用户的客户端浏览器访问ESAdminweb应用程序。
As you can see, query statistics in Version 8.5 is limited when compared to the flexibility of the configuration and the rich charts available with advanced query statistice in Version 9.1.
如您所见，与 9.1版本中的配置和丰富图表的灵活性相比，8.5 版本中查询统计数据还是相当有限的。
Compared to traditional methods, this new feature will greatly help you to enhance search performance and search quality by giving you an easy way to monitor and analyze your query statistics.
与传统方法相比，该新特性通过让您轻松监控和分析查询统计数据，将帮助您极大加强性能和搜索质量。
At this step, you need to use the tools discussed above to get statistics on the query: its response time, its detailed execution plan, and costs for later in-depth analysis.
在这一步中，需要使用上面讨论的工具来获取该查询的统计数据：其响应时间、详细的执行计划和成本，以便稍后进行深入分析。
You have learned how to analyze and tune the problem query from the perspective of statistics, predicates, and indexes.
您已经了解如何从统计数据、谓词和索引这几方面来分析和调优问题查询。
If the remote view contains a complex query, using table-level statistics such as the cardinality for the nickname over the view can be misleading.
如果远程视图包含一个复杂的查询，那么使用表级统计信息(例如视图昵称的基数)可能使人产生误解。
You should always include this in a query comparing configuration values to statistics values.
在比较配置值与统计值的查询中始终都应包含该谓词。
In addition, it discusses the role of the optimizer, including the OPTCOMPIND parameter, query directives, and internal statistics.
此外，还将讨论优化器的角色，其中包括OPTCOMPIND参数、查询命令和内部统计数据。
Instead, the optimizer gathers up-to-date statistics on every database table referenced in a query.
相反，优化器将对查询中引用的每个数据库表收集最新的统计数据。
You can see that DB2 has to evaluate less rows to execute the query when distribution statistics are available.
您可以看到，有分布统计信息的情况下，DB 2执行查询时需要计算的行数更少。
The query access plan produced after collecting these statistics is the same as the final plan in Example 3.
收集这些统计信息后生成的查询访问计划与示例3中的最后的计划相同。
Before automatic statistics profiling is activated, a query feedback warehouse must be created by running the SYSINSTALLOBJECTS stored procedure.
在触发自动统计信息配置之前，必须通过运行sysinstallobjects存储过程创建查询反馈仓库。
Annotate the problem query with relevant statistics to better understand what the DB2 optimizer is using for its estimations.
使用相关统计数据来注释有问题的查询，这样可以更好地理解DB 2使用哪些内容来进行评估。
In some cases, gathering the statistics might take longer than executing the query.
在某些情况下，收集统计信息需要的时间可能比执行查询的时间更长。
The optimizer calculates its cardinality estimate — that is, the estimated number of rows returned by the query — based on the statistics available.
优化器根据可用的统计信息计算基数的估计值，即预计查询返回的行数。
For statistical view, the ENABLE query optimization clause will cause the view, and its associated statistics to be used to improve the query optimization.
对于统计视图，ENABLEQUERYoptimization子句将导致该视图以及与之相关联的统计信息被用于改进查询优化。
The optimizer relies on statistics to properly cost alternative query execution plans (QEPs) and choose the most optimal plan.
优化器是依靠统计信息来计算可选查询执行计划（QEP）的开销，同时选择出最优的计划。
Collect statistics on your original SQL query.
收集关于原始sql查询的统计数据。
应用推荐