If the database designer has created a Primary partition Index on a table, queries should incorporate the partitioning column.

如果数据库设计者已在表上创建了主分区索引，那么查询应当与分区列结合。

youdao

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.

例如，我们无法针对分区的列使用标识列或者时间戳，而分区列需要是主键的组成部分。

youdao

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到头九个分区。

youdao