partitioning column信息详情

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.