PARTITION RANGE ALL 扫描全分区
PARTITION RANGE INLIST 不连续扫描多个分区
PARTITION RANGE ITERATOR 连续扫描多个分区
PARTITION RANGE SINGLE 扫描单个分区
range partition 范围分区 ; 创建范围划分 ; 范围分片
partition by range 范围分区
Range-partition 范围分割
Constant: Specifies the width of each data-partition range when the automatically generated form of the syntax is used.
Constant:在使用语法的自动生成形式时,指定每个数据分区范围的宽度。
Data is partitioned by node, so these queries can each be answered by a single partition, using an indexed range query.
数据根据节点分块,所以这些查询能分别在各自的数据块,通过一个索引过的范围查询得到结果。
应用推荐