partitioned table 中文意思是什麼

partitioned table 解釋
已分區表
  • partitioned : 分段的
  • table : n 1 桌子；飯桌，餐臺。2 手術臺；工作臺；游戲臺；賭臺；寫字臺。3 （飯桌上的）食物，酒菜，伙食；一...
  1. To repartition a partitioned table, use

    若要對已分區表進行重新分區，請使用
  2. Changes a key column of the partitioned view or table

    更改分區視圖或表的鍵列。
  3. This indicates that a table and all indexes on it are partitioned similarly

    這指示表以及其中的所有索引的分區類似。
  4. If reassigning a table s data as a partition to an already - existing partitioned table, or switching a partition from one partitioned table to another, the target partition must exist and it must be empty

    。如果要將表的數據作為分區重新分配給現有的已分區表，或者將分區由一個已分區表切換到另一個已分區表，則目標分區必須存在，並且必須為空。
  5. When a table or index uses multiple partitions, the data is partitioned horizontally so that groups of rows are mapped into individual partitions, based on a specified column

    當表或索引使用多個分區時，數據將被水平分區，以便根據指定的列將行組映射到各個分區。
  6. Db2 has evolved to significantly enhance the parallel processing capabilities of db2 applications processing partitioned table spaces

    到現在， db2已得到極大的發展，並大大地增強了那些處理分區表空間的db2應用程序的并行處理能力。
  7. In addition to performing switch operations that involve partitioned tables, alter table can be used to change the state of the columns, constraints, and triggers of a partitioned table just like it is used for nonpartitioned tables

    除了執行涉及到已分區表的switch操作外， alter table還可用於更改已分區表的列、約束和觸發器的狀態，就像它用於非分區表一樣。
  8. Some of the potential advantages that partitioned table spaces offer are listed below

    下面列出了分區表空間可以提供的一些潛在的優勢：
  9. A partitioned table space may contain only a single table

    ：分區表空間只能包含一個表。
  10. When creating a partitioned table space in db2 udb v7, db2 divides the data among the partitions according to the part clause of the create index statement

    在db2 udb v7中創建分區的表空間時， db2根據create index語句的part子句將數據劃分到幾個分區上。
  11. Then the administrator tunes the workload with the table hypothetically partitioned by quarter

    然後使用按季度假設分區的表來優化工作負荷。
  12. First, the administrator tunes the workload by means of a user - specified configuration with the table hypothetically partitioned by month

    首先，管理員通過用戶指定的配置和按月假設分區的表來優化工作負荷。
  13. Any computed column that is used as a partitioning column of a partitioned table must be explicitly marked persisted

    用作已分區表的分區依據列的任何計算列必須顯式標記為persisted 。
  14. Is not specified and the table is partitioned, the index is placed in the same partition scheme, using the same partitioning column, as the underlying table

    且該表已分區，則索引會與基礎表使用相同分區依據列並被放入同一分區方案中。
  15. A partitioned snapshot is used to initialize subscriptions to publications that have parameterized filters. referred to as a dynamic snapshot in previous versions of sql server. partitioned table

    合併復制中使用的一種篩選器，它將一個表中的行篩選器擴展到相關的表。
  16. Replicates the partition scheme for a partitioned table

    復制已分區表的分區方案。
  17. Reassigns all data in one partition of a partitioned table to an existing non - partitioned table

    將已分區表的一個分區中的所有數據重新分配給現有的未分區的表。
  18. Next, a nonpartitioned table is created with the same structure as the partitioned table and on the same filegroup as partition 2 of table

    所在的同一文件組中，創建與已分區表結構相同的未分區的表。
  19. You can have a partitioned index on a table that is not partitioned, and you can have a nonpartitioned index on a table that is partitioned

    可以在未分區的表中使用已分區索引，也可以在已分區表中使用未分區索引。
  20. If no location is specified and the table is not partitioned, the resulting table is included in the same filegroup as the clustered index

    如果未指定位置並且表是未分區的，則生成的表將包含在與聚集索引相同的文件組中。
分享友人
分享到 Line

分享到臉書