英语释义

1. the number of elements in a given mathematical set

片语

Minimum Cardinality最小基数

Cardinality Rules基数法则

cardinality counting基数计数

Base cardinality基础基数

CARDINALITY VIOLATION势违反

Cardinality principle基数原则

radix(Radix)人名；(法、德、西)拉迪克斯；(英)雷迪克斯

cardinality constraint基数约束

HIGH CARDINALITY高基数

cardinal numbers[数] 基数；基数词

cardinality ratio基数率

英汉例句

• The estimate for QUALIFIED_ROWS is obtained by multiplying the table cardinality (560,273 records) by the predicate filter factor (0.0014%).

  用表基数（560,273条记录）与谓词过滤因子 (0.0014%) 相乘就获得了 QUALIFIED_ROWS 的估计值。

• For example, cardinality restrictions specify the number of relationships that a class of individuals can participate in.

  例如，基数限制指定某类个体可以参与的关系的数量。

• Using the same sample data just discussed above, the following illustrates the difference in cardinality estimates with and without the use of statistical view for the query.

  下面使用以上讨论的相同的示例数据，阐释在使用和不使用查询的统计视图的情况下基数估计的差别。

• The number shown in each node is the optimizer's estimate for the cardinality of the underlying data source or operation node.

  每一个节点上显示的数字都是优化器对基础数据源或操作节点的基数的估计。

• As I discuss later in this article, two areas that often require particular attention are cardinality and optionality, or conformance strength.

  正如我将在本文后面所讨论的，常常需要特别注意的两个领域是基数和可选性，或者一致性强度。

• It is common practice to assume the predicates are independent of each other when computing their combined filtering effect on the cardinality estimate.

  在计算谓词对于基数估计值的组合过滤效果时，通常会假设这些谓词彼此之间是独立的。

• Strive for no more than one call after a single cardinality find on a home, or a next on an iterator retrieved from a collection.

  在本机上找到一个基数，或者通过迭代器从集合中检索到下一个基数后，尽量使用不超过一个调用。

• Change to the cardinality of fields in the output message, such as changing mandatory fields to optional fields, will break existing consumers.

  对输出消息中的字段的基数性进行更改(如将强制字段更改为了可选字段)将中断现有使用者。

• Therefore, omitting the maximum cardinality does not have any impact on the amount of allocated memory.

  因此，省略最大基数不会对已分配的内存量产生任何影响。

• Generate the access plan and see what the optimizer estimates the total cardinality (Number of rows) returned by the query will be.

  生成访问计划，查看优化器对该查询返回的总基数(行数)的估计值。

• Statements involving larger tables and joins of two or more tables are more likely to exhibit a change in query access plan as a result of the improved cardinality estimate.

  如果语句涉及到更大的表格和两个或者更多个表的连接的话，查询访问计划就很可能会因为基数估计值的提高而改变。

• The cardinality of the input schema can determine if multiple values can be selected.

  输入模式中的基数决定是否可以选择多个值。

• The intermediate profile is more technically oriented with details on data models, expressions, and cardinality information and is more suited for business architects.

  中级配置文件在技术上更针对于数据模型的细节、表达式及基数信息，并且它更适合于业务架构师。

• With this method, we can collect real cardinality for access plan operators.

  通过这种方法，我们就能够为访问操作者收集实际基数。

• To the right of each table reference is the table cardinality (in terms of both number of records and number of pages) and the estimated number of qualified rows.

  每个表引用的右边是表基数(依据记录的数量和页面的数量)以及合格行的估计数量。

• Both statistical views and REOPT allow the optimizer to compute a more accurate cardinality estimate and consequently choose an optimal query execution plan.

  统计视图和REOPT都使优化器可以计算出更精确的基数估计，而后选择一个最佳查询执行计划。

• Typically, the optimizer chooses merge scan join when the cardinality of the outer input is not obviously small and there is no efficient access method for the inner table.

  通常情况下，在外部输入的基数显然不小且对于内部表没有一种有效的访问方法时，优化器会选择合并扫描联接。

• You may have noticed that the query access plan itself did not change with the increase in cardinality estimate.

  您可能已经注意到了，查询访问计划本身并未随着基数估计值的增大而改变。

• You can leverage the extended use of multi-column statistics in DB2 9.5 to provide the optimizer more information to better estimate the cardinality in order to choose an optimal query access plan.

  您可以利用DB2 9.5中的多列统计信息的扩展用途来为优化器提供更多的信息，从而使优化器更好地估计基数，选择最佳的查询访问计划。