此表包含展示未验证规则百分比的分布表的数据。
This table contains the data of the distribution table showing the percentage of non-verified rules.
结果:列出了栀子原植物分类检索表、产地分布表和商品药材鉴定表。
Result: Listing the table of classification of the origin of botany and distribution of producing region and identification of crude drugs of Gardenia.
结果:列出了枳壳、枳实原植物分类检索表、产地分布表和商品药材鉴定表。
Result: a taxonomic table, a distribution table and a commercial drug identification table are given.
以不同开始接尘年度工龄分布表为基础,用寿命表法计算30年工龄累计尘肺发病率。
Based on exposure time by year and life table, the cumulative pneumoconiosis incidence of 30 year length of service was calculated.
实际数据分布表给了我们关于观察者和公司的数量的信息,为特定阶层的特定基准地位提供数据。
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.
Dojo布局小部件dijit.layout.BorderContainer在这里被用于页面布局,它被分为两个 dijit.layout.ContentPanes,一个用于汽车销售表,另一个用于分布表。
The Dojo layout widget dijit.layout.BorderContainer is used here for the page layout, split into two dijit.layout.ContentPanes, one for the car sale chart and the other for the distribution chart.
首先来分析一下,在没有分布统计信息,而只有cars表的基本统计信息及其索引的情况下,优化器选择的访问计划是怎样的。
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.
数据被物理地分布到跨多个表空间容器,这种方式对访问数据的应用程序执行方式产生重大影响。
The way in which data is physically distributed across table space containers can have a significant impact on how applications that access the data perform.
但是,如果没有数据分布,则数据库服务器根据表索引计算不同类型的过滤器的选择率。
However, in the absence of data distributions, the database server calculates selectivity for filters of different types based on table indexes.
然而在缺乏数据分布信息的情况下,优化器将基于表索引计算不同类型筛选器的选择性。
However, in the absence of data distribution information, the optimizer will calculate selectivity for filters of different types based on table indexes.
表3列示了不同工作负载中的消息分布的细节。
Table 3 lists the details of the message distribution in different workloads.
简单来说,片段级统计允许按片段存储列数据分布,并从组成的片段中构建表级别。
In simple terms, fragment-level statistics allows storage of column data distributions per fragment, and building the table level from its constituent fragments.
仅在收集了一个表中至少一个列的分布统计信息时,SYSCAT.COLDIST 才会包含关于该表的条目。
SYSCAT.COLDIST contains entries for a certain table only if distribution statistics have been collected for at least one of its columns.
在DPF环境中,根据CREATEtable语句中指定的分区键,表中的每个行被分布到一个分区上。
In a DPF environment, each table row is distributed to a database partition according to the distribution key specified in the CREATE table statement.
实际的比例取决于事实表中带有下推键的行的分布。
The actual proportion depends on the distribution of rows with the pushed-down keys in the fact table.
TABLE—在表级别创建分布。
Auto—在Automatic模式下,应用规则以判断是否需要创建片段级统计,否则默认为表级别分布。
AUTO - in Automatic mode, apply rules to determine if Fragment level Statistics should be created, otherwise default to table level distributions.
示例9:收集表和索引上的目录统计信息,包含分布统计信息
Example 9: Collect catalog statistics on the table and indexes with distribution statistics
收集索引上的详细抽样统计信息和表的分布统计信息。
Example 28. Collect detailed sampled statistics on indexes as well as distribution statistics for the table.
此外,如果需要收集CARS表中所有列的分布统计信息(频率统计信息和分位数统计信息),那么可以执行以下命令。
If, in addition, distribution statistics (frequency and quantile statistics) should be collected for all columns of the table CARS, execute the following command.
执行下列SQL,以找到跨节点的表的分布。
Execute the following SQL to find out the distribution of your table across the nodes.
包含用户数据表的值的分布信息的行。
Rows containing information about how the values of user data table are distributed. (So all the columns are affected).
接下来,为CARS表生成分布统计信息,并再次执行查询。
Next, generate distribution statistics for the table CARS and execute the query again. In this case, the optimizer chooses the following access plan.
将表空间分布在多个容器(这些容器映射到不同磁盘)。
Spreading tablespaces over multiple containers (which map to separate disks).
在分区数据库中,一个表可以分布在一个或多个数据库分区中。
Tables within a partitioned database can be located in one or more database partitions.
一旦将表分布到多个表空间中,就必须决定它们的物理存储器。
Once tables are distributed among table spaces, you need to determine their physical storage.
于是,对于大型的表,工作负载可以分布在多个分区上,而更小的表也可以存储在一个或多个数据库分区上。
A workload can then be spread across multiple partitions for large tables, while allowing smaller tables to be stored on one or more database partitions.
统计信息显示出表中的数据分布状况。
这些磁盘可以采用带状设置,且所有表空间都可以跨越该阵列进行分布。
These can be striped and all table Spaces can be spread out across the array.
分区背后的思想就是将一个表的数据分布在多个分区中,将该表中的一部分行存储在一个分区中,而将其他行存储在其他分区中。
The idea behind partitioning is to spread a table's data across multiple partitions, storing some of its rows in one partition and other rows in other partitions.
应用推荐