Google的书籍词频统计器简直叫人着迷，它可以搜索成千上万书籍关键“词”的使用频率——从1800年到今天，然后生成一个图表。
We’re totally hooked on Google’s new book search tool, which lets you search and graph the frequency of words in millions of books from 1800 to today.
其中之一是单词计数器，它统计某一单词在几个文件中出现的次数。
One of them is a word counter, which counts for certain word occurrence in several files.
如本文开头所提到的，统计数据是优化器作出关于访问路径的决策的基础。
As was mentioned at the beginning of this article, database statistics are the facts on which the optimizer makes decisions about access plans.
还有许多关于垃圾收集器本身的有趣的统计信息。
There are also many interesting statistics about the garbage collector itself.
通过采用片段级统计，服务器可以在片段级别创建和管理列统计。
With fragment-level statistics, the server can create and manage column statistics at the fragment level.
（但是，运行服务器统计数据收集脚本的客户机例外；这个客户机应该是第一个启动的客户机）。
The exception is the client that runs the server statistics collection script; this client should start with the first client.
您可以使用操作系统计数器来帮助理解数据库引擎外部的组件如何影响您的数据服务器。
You can use operating system counters to help you understand how components outside of the database engine affect your data server.
您还研究了参数标记/主变量的使用会为DB2优化器对分布统计信息的考虑带来怎样的限制。
You have also examined how the use of parameter markers/host variables may limit the consideration of distribution statistics by the DB2 optimizer.
正如您从清单1中所看到的，您有六个月以JSON表示的浏览器统计信息。
As you can see from Listing 1, you have six months of browser stats represented in JSON.
智能统计允许服务器判断现有的统计是否可以准确表示当前数据，或者是否需要对它们进行更新。
Smarter statistics allows the server to determine if the existing statistics accurately represent the current data or if they need to be refreshed.
活动统计与服务器、数据库、用户以及用户与数据库的连接相关，使管理员能够跟踪在系统中活动的用户。
The activity statistics relate to the server, databases, users, and connections of users to databases and enables administrators to track the users who are active on a system.
目录统计信息的更新将为优化器提供最新的地图，以便在整个地形中快速定位。
Updating the catalog statistics would provide the optimizer with the most current map to navigate quickly through the terrain.
这个示例解释说明了部分统计信息对于优化器估计基数的能力的影响。
This example illustrates the effect that partial statistics have on the ability of the optimizer to estimate the cardinality.
不一致的统计数据还会误导优化器选择糟糕的访问路径。
The inconsistent statistics may also mislead the optimizer into choosing a bad access path.
数据库管理器通过这些统计信息可以做出决策以提高SQL语句的性能。
With these statistics information database manager could make a decision that would increase the performance of an SQL statement.
统计信息还可帮助优化器确定表中有多少行正被查询，以及预测有多少行符合给定的条件。
Statistics also help the optimizer ascertain how many rows exist in tables being queried and predict how many rows will qualify for given conditions.
通过内部统计数据，我指的是系统目录中的统计数据，优化器可以确定最低成本的查询执行计划。
By internal statistics, I mean the statistics in the system catalogs that the optimizer USES to determine the lowest-cost query execution plan.
您可以从以上步骤看到，这个优化器基于可用的统计信息选择了最优的存取计划。
As you've seen in the steps above, the optimizer selects the optimal access plan based on available statistics.
尼尔森没有提供任何关于在电脑显示器上阅读的统计。
Nielsen did not provide any statistics on the reading time for the PC monitor.
而一旦生成了关于“TYPE”列的分布统计信息，优化器即可了解每种型号真正的出现频率。
When distribution statistics are generated for the column "TYPE," the optimizer knows the real frequency of each model.
这些视图包括一些包含对查询优化器有用的统计信息的列。
These views include columns containing statistical information that is useful to the query optimizer.
准确的索引信息和统计信息是查询优化器中基于成本的决策的基础。
Accurate index information and statistics are fundamental to cost-based decisions in the query optimizer.
图16显示了站点的浏览器统计数据。
优化器是依靠统计信息来计算可选查询执行计划（QEP）的开销，同时选择出最优的计划。
The optimizer relies on statistics to properly cost alternative query execution plans (QEPs) and choose the most optimal plan.
优化器根据可用的统计信息计算基数的估计值，即预计查询返回的行数。
The optimizer calculates its cardinality estimate — that is, the estimated number of rows returned by the query — based on the statistics available.
执行统计数据分析，确保DB 2优化器一直具有最新最需要的统计数据。
Perform statistics analysis to ensure that the DB2 optimizer always has the most current and the most needed statistics.
使DB 2统计信息保持最新：如果没有存储在DB 2系统目录中的统计信息，优化器在优化任何事物时都会遇到困难。
Keep DB2 statistics up-to-date: Without the statistics stored in the DB2 'system catalog, the optimizer will have a difficult time optimizing anything.
收集服务器的统计数据，并且每周都查看它们。
Collect your server stat data and review it on a weekly basis.
虚拟处理器是操作系统计划处理的进程。
A virtual processor is a process that the operating system schedules for processing.
虚拟处理器是操作系统计划处理的进程。
A virtual processor is a process that the operating system schedules for processing.
应用推荐