在这一步中，需要使用上面讨论的工具来获取该查询的统计数据：其响应时间、详细的执行计划和成本，以便稍后进行深入分析。
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.
此外，还将讨论优化器的角色，其中包括OPTCOMPIND参数、查询命令和内部统计数据。
In addition, it discusses the role of the optimizer, including the OPTCOMPIND parameter, query directives, and internal statistics.
通过对统计数据、谓词和索引的逐步分析，问题查询的性能大幅提升。
With the step-by-step analysis on statistics, predicate, and index, the performance of the problem query is improved significantly.
Informix提供的用来收集详细SQL查询计划和执行统计数据的最全面的工具是SETEXPLAIN实用程序。
The most comprehensive tool that Informix provides for collecting detailed SQL query plans and execution statistics is the SET EXPLAIN utility.
对于查询中的每个谓词，QueryTuner为谓词中的引用行和谓词的成本评估添加了统计数据注释。
For each predicate in the query, query Tuner adds statistics annotations for the referenced columns in the predicate and also the cost estimation for the predicate.
优化器的行为受三个关键因素的影响：Informix配置文件中OPTCOMPIND参数的值、查询命令和内部统计数据的准确性。
The behavior of the optimizer is influenced by three key factors: the value of OPTCOMPIND parameter in the Informix configuration file, query directives, and the accuracy of internal statistics.
您已经了解如何从统计数据、谓词和索引这几方面来分析和调优问题查询。
You have learned how to analyze and tune the problem query from the perspective of statistics, predicates, and indexes.
与传统方法相比，该新特性通过让您轻松监控和分析查询统计数据，将帮助您极大加强性能和搜索质量。
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.
搜索统计数据：查询操作、搜索器性能和处理时间、方法调用统计、以及对大多常用执行的查询。
SearchStats: Query operations, searcher performance and parsing times, method calls statistics, and most commonly executed queries.
该功能能够记录道路桥梁养护状况、道路及各构造物危害情况进行查询、显示查询结果和统计数据；
This function can record the maintenance condition of the road and bridge, check the damage condition of the road and other structures and show the inquire result and statistics.
该功能能够记录道路桥梁养护状况、道路及各构造物危害情况进行查询、显示查询结果和统计数据；
This function can record the maintenance condition of the road and bridge, check the damage condition of the road and other structures and show the inquire result and statistics.
应用推荐