... chromatic partitioning 染色划分 partitioning column 分区依据列 partitioning problem 划分问题 ...
基于1个网页-相关网页
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到头九个分区。
应用推荐