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:在使用语法的自动生成形式时,指定每个数据分区范围的宽度。
With TP, the user can manually define each data partition, including the range of values to include in that data partition.
通过TP,用户可以手动地定义每个数据分区,包括将被包括到那个分区的值的范围。
Data is partitioned by node, so these queries can each be answered by a single partition, using an indexed range query.
数据根据节点分块,所以这些查询能分别在各自的数据块,通过一个索引过的范围查询得到结果。
应用推荐