It is important to keep the statistics up to date, and to collect as much information about the tables and statistics as possible.
必须保持统计信息是最新的,并尽可能收集更多关于表和统计的信息。
In many cases, this will provide the optimizer with nearly as accurate statistics as the first command, but will return results much faster.
在很多情况下,这样做可以为优化器提供接近于第一个命令的精确性的统计信息,但是可以更快地返回结果。
While in buffering mode, the secondary stages any log page data coming from the HDR, onstat -g dri ckpt shows the log staging statistics as shown below.
处于缓冲模式下时,次要服务器会暂存来自 HDR 的任何日志页面数据,可以使用 onstat -g dri ckpt 显示日志暂存的统计数据,如下所示。
So the enrollment numbers are in and we thought we would share some statistics, as we like to do in this course; being computer scientists, we tend to gather lots of data.
登记加入我们的人数在这里,并且我们觉得我们能分享一些统计资料,我们在这次课程中也喜欢这么做,作为计算机科学家,我们要收集很多数据。
Because you don't know how much more time you've got-- You can make a guess based on statistics, but as we saw, there's wild unpredictability.
因为你不知道你剩下多少时间-,你可以根据数据进行猜测,但是我们都知道,不可预见性太难把握。
应用推荐