This table contains the data of the distribution table showing the percentage of non-verified rules.
此表包含展示未验证规则百分比的分布表的数据。
To assist ME engineers to complete the work of the station distribution table and process card;
协助ME工程师完成工位分配表和工艺过程卡;
Actual data Distribution table provide information on number of observation as well as number of company providing data for a particular benchmark position at a particular position class.
实际数据分布表给了我们关于观察者和公司的数量的信息,为特定阶层的特定基准地位提供数据。
Table 3 lists the details of the message distribution in different workloads.
表3列示了不同工作负载中的消息分布的细节。
However, in the absence of data distribution information, the optimizer will calculate selectivity for filters of different types based on table indexes.
然而在缺乏数据分布信息的情况下,优化器将基于表索引计算不同类型筛选器的选择性。
First analyze the access plan that the optimizer chooses when no distribution statistics are available, which is only basic statistics for the table CARS, and that its indexes exist.
首先来分析一下,在没有分布统计信息,而只有cars表的基本统计信息及其索引的情况下,优化器选择的访问计划是怎样的。
SYSCAT.COLDIST contains entries for a certain table only if distribution statistics have been collected for at least one of its columns.
仅在收集了一个表中至少一个列的分布统计信息时,SYSCAT.COLDIST 才会包含关于该表的条目。
You ran RUNSTATS with distribution and indexes all option, allowing write access to the table.
您运行带有分布和索引所有选项的RUNSTATS,从而允许对表进行写访问。
DM_GETCLUSTERS that returns a table of the clusters in the model together with a short text description about the field distribution in this cluster.
该函数返回一个表,其中包含模型中的集群,以及关于这个集群中字段分布的简短文本描述。
If the target table is distributed across database partitions, the source table must also be distributed using the same distribution method.
如果目标表跨多个数据库分区分布,则源表也必须使用相同的分布方法分布。
The optimizer USES information such as table sizes, availability of indexes, and data distribution to figure out the optimal way to answer the query.
优化器使用表大小、索引可用性以及数据分布等信息来确定响应该查询的最佳路径。
If a primary key is specified in the CREATE TABLE statement, the first column of the primary key is used as the distribution key.
如果在CREATEtable语句中指定了一个主键,那么主键的首列会被用作分配键。
The actual proportion depends on the distribution of rows with the pushed-down keys in the fact table.
实际的比例取决于事实表中带有下推键的行的分布。
Before examining distribution statistics, let's have a look at the basic statistics that are always collected for a table when RUNSTATS is executed.
在研究分布统计信息之前,我们先来看看基本统计信息,只要执行RUNSTATS即可收集这些表的相关统计信息。
With DPF, each row of a given table is placed in a specific database partition based on the hashed value of the table's distribution key, which is defined when the table is created.
在使用DPF时,根据表的分布键(这在创建表时定义)的散列值,把表的每一行放在特定的数据库分区中。
When you have determined that the table contains data that is not uniformly distributed, run RUNSTATS with the WITH DISTRIBUTION clause.
当您已确定表中包含不是统一分布的数据时,可以运行包含WITHDISTRIBUTION子句的RUNSTATS。
Table: Parasite species and geographical distribution of schistosomiasis.
表:血吸虫病寄生虫种类和血吸虫病地理分布。
Example 9: Collect catalog statistics on the table and indexes with distribution statistics
示例9:收集表和索引上的目录统计信息,包含分布统计信息
Example 5: Collect catalog statistics on the table and indexes without distribution statistics.
示例5:收集表和索引上的目录统计信息,不包含分布统计信息。
If, in addition, distribution statistics (frequency and quantile statistics) should be collected for all columns of the table CARS, execute the following command.
此外,如果需要收集CARS表中所有列的分布统计信息(频率统计信息和分位数统计信息),那么可以执行以下命令。
Example 28. Collect detailed sampled statistics on indexes as well as distribution statistics for the table.
收集索引上的详细抽样统计信息和表的分布统计信息。
Example 10: Collect catalog statistics on the table and enhanced statistics on the indexes, as well as distribution statistics.
示例10:收集表上的目录统计信息以及索引上的详细统计信息,包含分布统计信息。
Refer to Chapter 10 of the Performance Guide for the detailed table that the optimizer USES to calculate selectivity in the absence of data distribution.
关于在缺乏数据分布的情况下,优化器用以计算选择性的详细表,请参阅performanceGuide的第10章。
Example 6: Collect catalog statistics on the table and enhanced statistics on the indexes, but without distribution statistics.
示例6:收集表上的目录统计信息以及索引上的详细统计信息,不包含分布统计信息。
The low mode populates only the scalar statistical values (that is, no distribution information) of a table.
low模式只填充表的标量统计值(也就是说,没有分布信息)。
Example 16: Collect catalog statistics on table, with distribution statistics on columns deptno and deptname.
示例16:收集表上的目录统计信息,包含列deptno和deptname上的分布统计信息。
Next, generate distribution statistics for the table CARS and execute the query again. In this case, the optimizer chooses the following access plan.
接下来,为CARS表生成分布统计信息,并再次执行查询。
Table 8 shows a desirable node name configuration for a group of eight Oracle servers across two p590-managed systems and the distribution of "hdisk0" traffic across dual VIO servers.
表8给出一个更好的节点名配置方案,其中有8个Oracle服务器分布在两个p 590受管理系统上,“hdisk0”的通信流分布给两个VIO服务器。
Example 12: Collect catalog statistics on only the table, with basic column statistics for deptno and deptname and distribution statistics on mgrno and admrdept.
示例12:只收集表上的目录统计信息,包含deptno和deptname上的基本列统计信息以及mgrno和admrdept上的分布统计信息。
Example 12: Collect catalog statistics on only the table, with basic column statistics for deptno and deptname and distribution statistics on mgrno and admrdept.
示例12:只收集表上的目录统计信息,包含deptno和deptname上的基本列统计信息以及mgrno和admrdept上的分布统计信息。
应用推荐