• Use segmented or partitioned table Spaces.

    使用分段的或分区的表空间。

    youdao

  • Attaching a populated table to a partitioned table.

    将一个已填充的表添加到一个分区表。

    youdao

  • In general, the larger the table, the more reason to create it as a partitioned table.

    通常,表越大,就越有理由将其创建为分区的表。

    youdao

  • TableName: Identifies the partitioned table, by name, that a partition is to be removed from.

    TableName:按照名称指定将从中删除分区的分区表。

    youdao

  • TableName: Identifies the partitioned table, by name, that a new partition is to be added to.

    TableName:通过名称标识将添加新分区的分区表。

    youdao

  • DB2 10 can now automatically reorganize disjoint partition ranges of a partitioned table space.

    DB 210现在支持自动重新组织分区表空间的不相连分区范围。

    youdao

  • The following syntax examples demonstrate the steps necessary to create a hash-partitioned table.

    如下的语法示例展示了创建一个哈希分区表所需步骤。

    youdao

  • Q: How do I calculate the table and index size for a partitioned table (or any table for that matter)?

    Q:如何计算已分区表(或者任何相关的表)的表大小和索引大小?

    youdao

  • Ideally, each database partition in a hash-partitioned table should hold the same number of records.

    理想情况下,一个哈希分区表内的每个数据库分区都应具有相同数量的记录。

    youdao

  • If the SQL table was a partitioned table, each partition (member) could have a separate media preference.

    如果sql表是一个分区表,每个分区(成员)都可以有一个单独的媒介首选项。

    youdao

  • Limited partition scan is a method that allows DB2 to limit the scan of data in a partitioned table space.

    限定分区扫描允许DB 2将数据扫描限制在一个分区表空间中。

    youdao

  • Just as you can add or attach new partitions to a partitioned table, you can also remove existing partitions.

    正如可以向分区表添加或附加新分区一样,也可以删除现有分区。

    youdao

  • When such a statement is executed, a new table is created and logically made a part of the partitioned table.

    执行这样一个语句时,一个新表将创建,并在逻辑上构成分区表的一部分。

    youdao

  • Before an existing base table can be added (attached) to a partitioned table, the following conditions must be met.

    只有满足以下条件,现有基表才能被添加(附加)到分区表。

    youdao

  • Any indexes on the table being attached that match the existing local indexes on the partitioned table can be utilized.

    已分区表上的任何与现有本地索引相匹配的、附加在该表上的索引都可用。

    youdao

  • Under index-controlled partitioning, the concepts of partitioned table, partitioning index and clustering were all intertwined.

    对于索引控制的分区方法,分区的表、分区索引和群集这几个概念之间有点纠缠不清。

    youdao

  • Hash partitioning is the method by which the placement of each row in the partitioned table is determined. The method works as follows.

    散列分区是用于确定每一行在分区表中的位置的方法。

    youdao

  • The source table must be a nonpartitioned table or a partitioned table that has only one partition and no attached or detached partitions.

    源表必须是非分区表,或者是只拥有一个分区且没有已附加或已分离的分区的分区表。

    youdao

  • Starting in DB2 Version 9.7 Fix Pack 1, you can create an index over XML data on a partitioned table as either partitioned or nonpartitioned.

    从DB2Version 9.7FixPack1 开始,在分区的表上创建的XML数据索引可以是分区的,也可以是不分区的。

    youdao

  • Reorganizing a partition will put the entire table offline if the partitioned table has any global indexes besides XML column path indexes.

    如果已分区表包含任何xml列路径索引以外的其他全局索引,重组一个分区会导致整个表脱机。

    youdao

  • You are either designing a new table that will be hash-partitioned, or you have an existing hash-partitioned table that might have a data skew problem.

    您正在设计一个将被哈希分区的新表,或者您已经有了一个哈希分区的表,并且此表有可能会存在数据倾斜问题。

    youdao

  • Managing a range-partitioned table that includes one or more XML columns isn't much different from managing a range-partitioned table with only relational columns.

    与管理只包含关系列的范围分区表相比,管理包含一个或多个XML 列的范围分区表的差异并不大。

    youdao

  • When lookup tables are used in joins with other large partitioned table spaces, you can maximize the parallelism in the join by partitioning the lookup tables as well.

    当将查找(lookup)表与其他较大的分区的表相连接时,通过将查找表也进行分区,可以最大化并行度。

    youdao

  • A new, empty partition can be added to a partitioned table by executing the ALTER TABLE statement with the ADD PARTITION option specified; the syntax used looks like this

    可以通过执行ALTERTABLE语句并指定ADDPARTITION选项来向一个分区表增加一个新的空分区,使用的语法如下所示

    youdao

  • When you create a range-partitioned table in DB2 z/OS, the underlying table space is also partitioned and such a partitioned table space can not hold more than one table.

    在DB2z/OS 中创建一个范围分区的表时,底层的表空间也被分区,并且这样一个分区的表空间无法容纳多个表。

    youdao

  • If the table is a range clustered table (that does not support row compression), you can consider switching it to become a range partitioned table (that supports row compression).

    如果表是一个范围集群表(不支持行压缩),可以考虑将其变换为范围分区表(支持行压缩)。

    youdao

  • The best practice to speed up data roll-in is to ensure that, prior to roll-in, the table being attached has indexes that exactly match all local indexes on the partitioned table.

    加速数据滚入的最佳实践是,确保在滚入之前,附加表已具有与已分区表上所有本地索引精确匹配的索引。

    youdao

  • Listing 3 creates a range-partitioned table with relational and XML data, rolls out (detaches) a partition containing old data, and rolls in (attaches) a partition containing recent data.

    清单3创建一个包含关系和XML数据的范围分区表,滚出(分离)包含老数据的分区,滚入(附加)包含最近数据的分区。

    youdao

  • If dependents such as staging tables or refresh immediate MQTs exist on the partitioned table, the second phase starts automatically after these dependents are refreshed via SET INTEGRITY.

    如果在已分区表上存在类似临时表或者立即刷新MQTs之类的依赖表,第二阶段会在利用SETINTEGRITY刷新了这些依赖表后自动启动。

    youdao

  • Those interested in this can read the white paper Partitioned Table and Index Strategies Using SQL Server 2008.

    对此感兴趣的读者可以阅读白皮书《使用SQL Server 2008的分区表和索引策略》。

    youdao

$firstVoiceSent
- 来自原声例句
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定