partitioning column信息详情
分配柱
column───n.纵队,列;专栏;圆柱,柱形物
fluted column───凹槽柱
column chromatography───柱层析(法),柱色谱(法);柱层析法;[分化]柱色谱法
buckling column───屈曲柱
remarks column───[计]备注栏
column heading───[计] 列标题,栏标题;[计]栏标题
in column───编队
rectification column───[化] 精馏塔;[化工]精馏塔
chromatography column───[建] 色谱精炼柱;层析柱
For example, one cannot use identity columns or timestamps for the partitioning column, but the partitioning column has to be part of the primary key.───例如,我们无法针对分区的列使用标识列或者时间戳,而分区列需要是主键的组成部分。
Because there is a predicate, cust_order_number between 100000 and 580000, on the partitioning column, the optimizer is able to limit the TBSCAN to the first nine partitions.───因为有一个谓词,cust_order_number处于100000到580000之间,在分区列上,优化器能够限制TBSCAN到头九个分区。
If the database designer has created a Primary partition Index on a table, queries should incorporate the partitioning column.───如果数据库设计者已在表上创建了主分区索引,那么查询应当与分区列结合。
The partitioning column must be in the same ordinal location in the select list of each SELECT statement in the view .───在视图中,分区列必须位于每个SELECT语句的选择列表中相同的序号位置。
The actual column, known as a partitioning column, is specified in the CREATE TABLE or CREATE INDEX statement.───实际列(也称为分区列)是在CREATETABLE或CREATEINDEX语句中指定的。
The constraints should be in an enabled and trusted state for them to meet the previously mentioned conditions of the partitioning column.───约束应处于启用和信任状态,以使它们满足分区列的上述条件。
To meet the conditions of the partitioned view, there should be only one partitioning constraint on the partitioning column.───若要满足分区视图的条件,在分区列上应只有一个分区约束。
A way of partitioning a table or index by specifying partitions to hold rows that have ranges of values from one partitioning column.───一种对表或索引进行分区的方法,指定一些分区来保存一个分区依据列中值在一定范围内的行。
The partitioning column cannot be an identity, default or timestamp column.───分区列不能是标识、默认值或timestamp列。
If the database designer has created a Primary Partition Index on a table, queries should incorporate the partitioning column.