它将显示页面名称和访问计数(页面已被请求的次数)。
It will show the name of the page and the access count (number of times that page has been requested).
URL访问计数:map函数处理web页面的请求日志。
Count of URL Access Frequency: The map function processes logs of web page requests and outputs.
通过仔细地观察读写序列计数,可以进一步确定访问是顺序的还是随机的。
By looking at the read and write sequence counts in detail, you can further determine if the access is sequential or random.
收集不依赖于连接(JOIN)的基本访问(表的索引扫描和表扫描)的计数。
Gather counts for base accesses (an index scan or a table scan of a table) that are not dependent on a join.
例如,Web访问统计信息(按当前所编辑的)只不过是以各种方式进行分组的频率计数。
For example, Web-access statistics (as currently compiled) are little more than frequency counts grouped in various ways.
您收集了这些统计数据之后,会得到如图10所示的新访问计划图。
After you collect those statistics, you get the new access plan graph shown in Figure 10.
不充分或不准确的统计数据会导致对候选访问路径评估不准确,这也是选择低效访问路径的最常见原因。
Insufficient or inaccurate statistics lead to inaccurate cost estimates for the candidate access paths and is the most common reason for the selection of inefficient access paths.
在选择数据的访问路径时,如果没有正确的列分布统计数据,DB 2可能没有足够的信息来做出最佳的选择,尤其是如果数据出现严重误差。
Without correct column distribution statistics, DB2 may not have enough information to make the best choice when choosing an access path to the data-especially if data is heavily skewed.
不一致的统计数据还会误导优化器选择糟糕的访问路径。
The inconsistent statistics may also mislead the optimizer into choosing a bad access path.
使用JOPR,管理员可以用可视化的方式访问一些重要的运行时参数或统计数据,同时也可以得知这些参数和统计数据是否超标或过低。
With JOPR, administrators have access to graphical views of key run-time parameters or statistics and can also be notified if these exceed or go below certain limits.
统计数据冲突:不一致的统计数据可能会导致优化器对成本评估错误,作出错误的访问计划评估决策。
Conflicting statistics: Inconsistent statistics may cause the optimizer to derive the wrong estimated costs and to make the wrong decision on access plan assessment.
因为建立对数据源的访问要考虑很多种情况,设计数据图本身可以作为另一篇文章的主题。
Designing a data graph could be the subject of another article on its own as there are many scenarios to consider when building access to a data source.
如本文开头所提到的,统计数据是优化器作出关于访问路径的决策的基础。
As was mentioned at the beginning of this article, database statistics are the facts on which the optimizer makes decisions about access plans.
使用可用于DB2优化器的新统计数据,对数据的访问可以显著改善。
With the new stats available to DB2’s optimizer, access to the data can be dramatically improved.
病人必须访问某种医疗设备来收集并分析他或她的关键统计数据,从而获得有关其所患疾病的警示、趋向和异常。
A patient must visit a healthcare facility to have his or her vital statistics collected and analyzed for warnings, trends, and anomalies.
如果统计数据已更改一段时间,并且您的当前语句拥有理想的访问路径,DB 2将基于旧语句继续使用该路径。
If statistics haven't changed in a while and you have a desirable access path with current stats, DB2 will continue to use that path based on the old stats.
每个节点都有统计数据、评估成本、选择信息等用来确定访问计划流的注释。
And each node is annotated by statistics, estimated costs, selectivity information and so forth that are used to determine the access plan flow.
如果无法获得当前的统计数据,优化器就可能会基于不准确的默认统计数据选择低效的访问计划。
If current statistics are not available, the optimizer may choose an inefficient access plan based on inaccurate default statistics.
在访问计划图的表或索引节点上会有一个RUNSTATSTIMESTAMP属性,它表示收集统计数据的时间。
There is an attribute RUNSTATS TIMESTAMP on the table or index node of the access plan graph that indicates the last time when the statistics were collected.
丢失的统计数据会让优化器高估或低估谓词的选择性,最终会选择低效的访问路径。
Missing statistics can cause the optimizer to overestimate or to underestimate the selectivity of a predicate, and eventually to select an inefficient access path.
SPARQL不需要设计数据访问接口。
SPARQL doesn't require you to design a data access interface.
它表明的网页的网址访问必须符合你输入网址的目标,但如果有任何额外的数据结束时,他们的网址然后的目标仍将是计数。
It indicates that the URL of the page visited must match what you enter for the goal URL, but if there is any additional data at the end of their URL then the goal will still be counted.
如果它是一个TransactionMsg,那么就访问修改行的列表,并用该列表的大小来更新计数器。
If it's a TransactionMsg, then the list of modified rows is accessed, and the counter is updated by the size of the list.
JeffGoldberg内容丰富的演说告诉你为什么不应该过度依赖访问统计和计数器;
Jeff Goldberg’s informative rant on why you shouldn’t rely on access statistics and hit counters.
我的第二个性能技巧是,在访问和分析操作系统和Domino统计数据时,使用最新的集成平台统计数据。
My second performance tip is to use the new integrated platform statistics for the access and analysis of operating system and Domino statistics.
准确而全面的统计数据能帮助生成良好的访问路径建议,当然,索引advisor工具执行时要有准确的统计数据。
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工具:收集所需统计数据以完成访问路径的建议。
Statistics advisor: recommendations for collecting the required statistics to facilitate access path selection.
基数(cardinality)表示访问计划操作符所返回的行的估计数目。
The cardinality represents the estimated number of rows returned from the access plan operator.
作为对比,我从netApplications找了些数据。它公布的对浏览器的统计数据是基于160,000,000个不同的人访问40,000个站点通过他们的web分析服务得出的。
For comparison, I looked at data from net Applications, which releases browser statistics based on the 160 million different people who visit a network of 40,000 sites using its Web analytics service.
作为对比,我从netApplications找了些数据。它公布的对浏览器的统计数据是基于160,000,000个不同的人访问40,000个站点通过他们的web分析服务得出的。
For comparison, I looked at data from net Applications, which releases browser statistics based on the 160 million different people who visit a network of 40,000 sites using its Web analytics service.
应用推荐