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.
在这一步中,需要使用上面讨论的工具来获取该查询的统计数据:其响应时间、详细的执行计划和成本,以便稍后进行深入分析。
On the command line, you need to specify the interval (in seconds) to use when reporting statistics.
在命令行上,您需要指定要在报告统计信息时使用的间隔(以秒为单位)。
For the examples in this article, I will use annual baseball statistics for all players since 1882.
对于本文中的例子,我将使用自1882年以来每年对所有棒球运动员的技术统计作为数据。
This instructs the algorithm to only use the DC columns for clustering, for the other columns, only statistics are collected.
这说明该算法只使用集群的dc列,对于其他的列来说,则只收集统计信息。
You have also examined how the use of parameter markers/host variables may limit the consideration of distribution statistics by the DB2 optimizer.
您还研究了参数标记/主变量的使用会为DB2优化器对分布统计信息的考虑带来怎样的限制。
A statistics profile is generated automatically for use by the automatic statistics collection process to schedule RUNSTATS.
统计信息配置文件是自动生成的,自动统计信息收集过程将用它来调度RUNSTATS。
Statistics about bus use may sound yawningly dull, but there is some really interesting stuff amongst this morning's data from the Office for National Statistics.
关于公交车使用的统计数据听起来也许让人乏味的打哈欠,但是今天早上一份来自国家统计局的数据显示,这其中还有不少有趣的现象。
The sample shows that distribution statistics are of limited use when used in conjunction with parameter markers.
这个示例表明,如果将分布统计信息与参数标记一起使用,分布统计信息的作用就会受到限制。
This article has given you the information you need to use UPDATE STATISTICS in a way that will make your life much easier.
本文提供的信息可以帮助您以一种轻松得多的方式使用UPDATESTATISTICS。
Use a separate client to run the server statistics collection script (more on this later).
使用一个单独的客户机运行服务器统计数据收集脚本(后面详细讨论)。
After both applications have been successfully installed and started, you can use the Cache Monitor to look at statistics for the World Clock portlet.
已成功安装并启动了这两个应用程序之后,就可以使用缓存监视器来查看WorldClock Portlet的统计数据。
Here is an example of how to use the UDF to obtain the compression statistics report for table rowcomp.mdc.
下面是关于如何使用该U DF获得表rowcomp . MDC的压缩统计信息报告的例子?
If you are using an Ethernet, you can also use the entstat command to display device-driver statistics.
如果您使用的是以太网,那么还可以使用entstat命令来显示设备驱动器的统计信息。
For Ethernet, you can use the entstat command to display device-driver statistics.
对于以太网,您可以使用entstat命令来显示设备-驱动程序统计数据。
"The CEA, the European insurance federation, said the verdict was" bad news, "arguing that the use of evidence-based statistics was" indispensable in actuarial science.
欧洲保险联盟(European insurance federation)称该判决是一个“坏消息”,他们辩解称采用事实统计数据是“保险精算学必不可少的一环”。
Some of your managers put the data and statistics right at the beginning, while others use appendices at the end.
有些经理们把数据和统计信息放在报告的最前面,而另外那些经理在报告的末尾用了附录。
Predicates with concrete values are important for the optimizer to be able to use available distribution statistics.
为使优化器能够使用可用的分布统计信息,带有具体值的谓词极为重要。
You can leverage the extended use of multi-column statistics in DB2 9.5 to provide the optimizer more information to better estimate the cardinality in order to choose an optimal query access plan.
您可以利用DB2 9.5 中的多列统计信息的扩展用途来为优化器提供更多的信息,从而使优化器更好地估计基数,选择最佳的查询访问计划。
After the proper monitor switches are on, you can use the GET SNAPSHOT command from the same DB2 command window to collect monitoring statistics information.
在打开合适的监控器开关之后,您可以在同一db2命令窗口使用GETSNAPSHOT命令来收集监控统计信息。
We cover the use of the IBM JVM trace to provide startup statistics in the next section.
我们将在下一节中讨论如何使用IBMJVM跟踪提供启动统计数据。
The following example forces the use of fragment-level statistics by setting the STATLEVEL at creation time.
下面的例子在创建时设置了STATLEVEL,将强制使用片段级统计。
It is through this interface that you can gather thread statistics by making use of functions available in the IBM-released JVM.
通过该界面,您可以利用IBM发布的JVM中可用的功能收集线程统计信息。
Use UPDATE STATISTICS LOW if the number of rows has changed significantly or after migration from previous version of database server.
如果被更改的行数很多,或者刚在不同版本的数据库服务器之间完成迁移,则应使用UPDATESTATISTICSLOW。
It then lists all of the DLLs in use by the process, with their sizes, followed by a summary of statistics about the working set and page-file usage.
然后列出进程使用的所有dll及其大小,后面是工作集和分页文件使用的统计信息。
Like Japanese kabuki theatre, in which characters use exaggerated gestures to energise the audience, the country's statistics unrealistically magnify both good news and bad.
在日本的歌舞伎座剧场里,表演者利用夸张的举止来感染观众,同样,这个国家的宏观经济数据不切实际地同时夸大利好消息和利空消息。
The CEA, the European insurance federation, said the verdict was "bad news," arguing that the use of evidence-based statistics was "indispensable in actuarial science."
欧洲保险联盟(European insurance federation)称该判决是一个“坏消息”,他们辩解称采用事实统计数据是“保险精算学必不可少的一环”。
Do the following to allow the server to build and use Fragment Level statistics?
执行下面的操作,将服务器配置为构建和使用片段级统计。
My second performance tip is to use the new integrated platform statistics for the access and analysis of operating system and Domino statistics.
我的第二个性能技巧是,在访问和分析操作系统和Domino统计数据时,使用最新的集成平台统计数据。
My second performance tip is to use the new integrated platform statistics for the access and analysis of operating system and Domino statistics.
我的第二个性能技巧是,在访问和分析操作系统和Domino统计数据时,使用最新的集成平台统计数据。
应用推荐