虽然这个访问计划比使用具体值但没有分布统计信息情况下的访问计划好,但不如既使用具体值又有分布统计信息时的访问计划。
Although the access plan is better than the access plan with concrete values without distribution statistics, it is worse than the access plan with concrete values with distribution statistics.
然后它用它的双亲请求,根据连接的描述找到正确的数据库统计值,并根据sql键字符串找到语句统计值。
It then USES its parent request to find the right database statistics based on the connection's description, and to find statement statistics based on the SQL key string.
信息分析员将分类用于统计组中的聚集测度,统计组有总数、平均数、最小值和最大值等。
Information analysts use classifications for aggregating measures in statistical groupings such as totals, averages, minima, and maxima.
数据库的统计值持有有关连接次数的信息,并聚合每个单独语句的额外统计值。
The database statistics hold information about connection times and aggregate additional statistics for each individual statement.
统计数据丢失:当统计数据丢失后,优化器假设一个默认值来确定成本,这非常不准。
Missing statistics: When statistics are missing, the optimizer assumes the default values to determine costs, which could be completely inaccurate.
AUTO_STAT _ MODE:有一个默认值1,它支持自动升级统计操作(片段级统计为ON时)。
AUTO_STAT_MODE: Has a default value of 1, which enables the automatic update statistics operation (fragment-level statistics is on).
在这里,我没有显示在操作统计值中查询嵌套统计值的支持代码(可以在本文的源代码中看到它)。
I don't show the supporting code for looking up nested statistics in an operation statistics here (you can see it in the article source code).
这样,操作(例如servelt)的统计值就持有每个数据库的性能统计。
This way, statistics for operations (such as servlets) hold performance statistics for each database.
该列有很多重复的值(频率统计信息),或者该列的值分布不均匀,即它们在某些局部是聚合的(分位数统计信息)。
The column has many duplicates (frequency statistics), or the values of the column are not evenly distributed, which means they are clustered in certain areas (quantile statistics)
通过深入在表描述符上的列统计信息,您可以发现在IN清单上的6个元素恰好是频率统计信息上的最后6个值。
By drilling down to the column statistics in the table descriptor, you can discover that the six elements in the in list predicate happen to be the bottom six values in the frequency statistics.
因为我想根据请求更新数据库的性能,所以我将采用compositepattern跟踪由其他统计值持有的统计值。
Because I want to update database performance by request, I'll use a composite pattern to track statistics held by other statistics.
键识别这是哪个统计信息,例如document_size,而值表示这个统计的值。
The key identifies which statistic it is, for example, document_size, with the value indicating the value for that particular statistic.
在报告中,他们没有包含实际运用的统计学检验、显著性(p值(统计学中进行检验决策的一个重要依据——译者注))、以及调查的每一组别里个体的数量。
What isn't included in the actual report are the actual statistical tests used, statistical significance (p values), and Numbers of subjects in each group studied.
英国统计局发布2010年2季度修正后的GDP增速,2季度GDP增速从一个月之前发布的初始统计值1.1%提升至1.2%。
The Office for National Statistics' second estimate for growth showed GDP rose a quarterly 1.2% between April and June, up from its initial estimate of 1.1% released a month ago.
这就让我可以把嵌套请求的操作统计值与它们双亲的统计值关联起来(例如,哪个servlet请求造成了这个数据库访问)。
This allows me to associate the operation statistics for nested requests with the statistics of their parents (for example, what servlet request caused this database access).
在没有列组统计信息的情况下再次收集统计信息的话,优化器会选择一个类似如下所示的查询访问计划,它的基数估计值为2。
A query access plan similar to the following is chosen by the optimizer, with a cardinality estimate of 2.
在没有列组统计信息的情况下再次收集统计信息的话,优化器会选择一个类似如下所示的查询访问计划,它的基数估计值小于2。
A query access plan similar to the following is chosen by the optimizer, with a cardinality estimate under 2.
基于模糊统计基础上的集值统计,能有效地确定具有随机、模糊性质的军机易损性评估指标的安全度值;
The airplane vulnerability safety degree value, which is stochastic and fuzzy, can be calculated accurately by set-valued statistics based on fuzzy statistics.
计算结果表明:变形统计值与变形监测值吻合较好,统计复相关系数较大,估计标准误差较小。
The calculation results show that the statistic and monitoring value are fairly identical, multiple correlation coefficients bigger and estimated standard error smaller.
继高阶统计地震子波相位估计方法之后,将基于高阶统计的幅值重构方法也引入其中,从而完成了完整的高阶统计地震子波估计理论。
Import magnitude reconstruct method to estimation wavelet base on high-order statistics after phase estimation theory, and perfecting the method of estimation wavelet though high-order statistics.
本文提出了属性统计方法,并指出,概率统计、模糊统计、集值统计是它的特殊情况。
It is shown that probabilistic statistics, fuzzy statistics and set-valued statistics are special cases of attribute statistics.
与DNS的统计值相比,除了近壁区之外,在流场的大部分区域,模拟值与精确的统计值基本一致。
It is found that generally the simulated values are in agreement with the DNS data in most flow regions, except in the near-wall region.
除了统计浓度值的算术平均值外,还应统计出主要风向下的浓度值,为大气预测提供本底数据。
Then besides counting up, it should count up the loading values of cardinal wind as the background data for atmospheric forcast.
基于路面实测数据进行了统计分析,得到了路面使用性能参数的统计分布模型及其参数估计值。
Based on the measured data, the statistical distribution model and estimate value of statistical parameter were been obtained.
本课题使用SPSS 13.0统计分析软件包对样本观察值进行统计描述与统计推断。
The subject makes use of stastisic software SPSS 13.0 to stastistic description and stastistic inference.
目前交通噪声预测使用的FHWA模型在实际应用以人工方式来统计通过的车辆数和车型,人工成本高,统计值容易产生偏差。
Now the FHWA model used in traffic noise prediction get the number and type of vehicles by artificial way, the labor cost is high and the statistical value often not very accuracy.
计算结果表明:变形统计值与变形监测值吻合较好,统计复相关系数较大,估计标准误差较小。
This paper achieves noise reduction by using wavelet packet transform, semisoft shrinkage function, Donoho standard deviation estimate and threshold obtain based on statistics.
本文主要是研究几类统计模型的参数估计和有限总体中未来观察值的预测等统计推断问题。
The thesis is concerned with statistical inferences including parameter estimation and prediction of future observations in finite populations under several statistical models.
介绍了大坝观测资料统计模型的建模方法 ,并结合实例 ,探讨了观测资料缺值对统计模型精度的影响及其处理的方法 。
The time series method is used to extract the regular part from the residual series received by modeling of observed data.
介绍了大坝观测资料统计模型的建模方法 ,并结合实例 ,探讨了观测资料缺值对统计模型精度的影响及其处理的方法 。
The time series method is used to extract the regular part from the residual series received by modeling of observed data.
应用推荐