The system's main functions include system management, outage management, outage application management, outage analysis, work order management, query and statistics and so on.
系统的主要功能模块包括系统管理、停电管理、停电申请管理、停电分析、工作票倒闸票管理、查询统计等模块。
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.
您已经了解如何从统计数据、谓词和索引这几方面来分析和调优问题查询。
In addition, it discusses the role of the optimizer, including the OPTCOMPIND parameter, query directives, and internal statistics.
此外，还将讨论优化器的角色，其中包括OPTCOMPIND参数、查询命令和内部统计数据。
Setting the AUTOTRACE option ON will enable the display of explain and statistics information for each statement executed in that session along with query results, until the AUTOTRACE is disabled.
将AUTOTRACE选项设置为ON 将允许显示该会话中执行的每条语句的说明和统计信息，以及查询结果，直至 AUTOTRACE 被禁用。
The following query demonstrates the kind of performance benefit that the improved statistics, notably HIGH2KEY and LOW2KEY, can offer.
下面的查询演示了改进后的统计信息，尤其是HIGH2KEY和LOW2KEY，在性能方面带来的好处。
At this step, you need to dig into the statistics you collected above and take a good look at the query execution plan.
在这一步中，需要挖掘上面所收集的统计数据，并仔细查看查询执行计划。
With the step-by-step analysis on statistics, predicate, and index, the performance of the problem query is improved significantly.
通过对统计数据、谓词和索引的逐步分析，问题查询的性能大幅提升。
When automatic statistics profiling is enabled, information about database activity is collected and stored in a query feedback warehouse.
当启用自动统计信息配置时，数据库活动的有关信息被收集并存储在查询反馈仓库中。
Accurate index information and statistics are fundamental to cost-based decisions in the query optimizer.
准确的索引信息和统计信息是查询优化器中基于成本的决策的基础。
To ensure that the optimizer selects the best query plan, it is important to keep internal statistics current and accurate.
为了确保优化器选择最佳的查询计划，使内部统计数据保持为最新并且最准确的十分重要。
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子句将导致该视图以及与之相关联的统计信息被用于改进查询优化。
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 版本中查询统计数据还是相当有限的。
The optimizer relies on statistics to properly cost alternative query execution plans (QEPs) and choose the most optimal plan.
优化器是依靠统计信息来计算可选查询执行计划（QEP）的开销，同时选择出最优的计划。
SearchStats: Query operations, searcher performance and parsing times, method calls statistics, and most commonly executed queries.
搜索统计数据：查询操作、搜索器性能和处理时间、方法调用统计、以及对大多常用执行的查询。
For the query in this article, the basic statistics of the referenced tables, columns and indexes were collected, such as the table cardinality, column cardinality, an so on.
对于本文中的查询，收集了引用表、列、索引的统计数据，如表基数、列基数等等。
With the new index created, and statistics collected on it, the optimizer corrects the cardinality estimate of the query access plan.
然后优化器会使用新创建的索引和在其上收集的统计信息来更正查询访问计划的基数估计值。
You should also consider executing runstats on the MQT, so that the query optimizer has accurate information about the number of rows in the MQT and other statistics.
您还应该考虑在MQT 上执行runstats，以便查询优化器拥有关于 MQT 中的行数以及其他统计信息的准确信息。
There is a new API to help end users view available destinations and query them to find JMS statistics such as active queue count, queue depth, number of messages etc.
有一个新的API可以帮助最终用户查看可用的目的地（destinations）并对其进行查询以得到JMS统计信息，如活动队列数量、队列深度及消息数量等等。
The most comprehensive tool that Informix provides for collecting detailed SQL query plans and execution statistics is the SET EXPLAIN utility.
Informix提供的用来收集详细SQL查询计划和执行统计数据的最全面的工具是SETEXPLAIN实用程序。
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.
优化器的行为受三个关键因素的影响：Informix配置文件中OPTCOMPIND参数的值、查询命令和内部统计数据的准确性。
With Query Annotation, you can format the SQL statement for improved readability and navigation and see which statistics are being used at the table and column level.
可以使用QueryAnnotation控制sql语句的格式以提高可读性，还可以查看表级和列级使用的统计数据。
Improved statistics collection and query explain file.
改善的统计信息收集和查询解释文件。
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.
对于查询中的每个谓词，QueryTuner为谓词中的引用行和谓词的成本评估添加了统计数据注释。
Next, generate distribution statistics for the table CARS and execute the query again. In this case, the optimizer chooses the following access plan.
接下来，为CARS表生成分布统计信息，并再次执行查询。
Select a query and click Tune to transfer the query to IBM Data Studio to format the query, analyze the access plan, or check whether statistics are current and optimal.
选择一个查询并单击Tune 可将其转化为IBMDataStudio，来格式化查询、分析访问计划、或者检查统计是否存在且最优。
mytop also provides real-time and historical data about key-buffer and query-cache efficiency, and statistics about the queries being run.
mytop还提供了一个有关关键字缓冲区和查询缓存效率的实时数据和历史数据，以及有关正在运行的查询的统计信息。
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.
与传统方法相比，该新特性通过让您轻松监控和分析查询统计数据，将帮助您极大加强性能和搜索质量。
From the query annotation information, you can easily see what kinds of statistics are available, and what kinds of statistics are missing.
从查询注释信息中，您可以很容易地看到哪些统计数据可用，哪些统计数据丢失。
Query optimization is crucial in dealing with databases, and UPDATE STATISTICS does just that.
在处理数据库时，查询优化至关重要，而UPDATESTATISTICS正是用于此目的。
应用推荐