It is a good idea to run a RUNSTATS-equivalent tool to gather statistics on the remote data.
运行与RUNSTATS等效的其他工具来收集关于远程数据的统计信息也是很好的做法。
To gather statistics and DDL for only certain tables and related objects, use the following command.
为了仅仅收集某些表和相关对象的统计数据和ddl,可使用下列命令。
Using this feature, you can gather statistics and performance data for multiple servers and display them graphically to users.
使用这一特性,您可以对多台服务器收集统计数据和性能数据,并以图形化方式将它们显示给用户。
This avoids another scan of the index in order to gather statistics. The following examples illustrate some of the options available to do this.
这将避免为了收集统计信息而进行的另一项索引扫描。
Ask your followers to choose their favorite of three or four options, and you can instantly gather statistics that help you to make business decisions.
请您的追随者从三到四个选项中选择他们喜欢的选项,然后您就可以立即收集到有助于您做出商业决策的统计信息。
Note that Benchmark by default executes the task several times in order to gather statistics, and these multiple executions have the nice side effect of eliminating OSR as a performance issue.
注意,Benchmark在默认情况下会多次执行任务来收集统计数据,多次执行的副作用是消除OSR对性能的影响。
Gather statistics and DDL for a database subset.
收集数据库子集的统计数据和ddl。
Gather statistics and DDL for a database subset.
收集数据库子集的统计数据和ddl。
应用推荐