# Range 分区表

__*范围分区表*__

```
CREATE TABLE test.t1 (x INT) PARTITION BY RANGE (x) (
    PARTITION p0 VALUES LESS THAN (5),
    PARTITION p1 VALUES LESS THAN (10));

...

tidb> explain select * from test.t1 where x between 1 and 4;
+-------------------------+------------+-----------+------------------------+------------------------------------+
| id                      | estRows    | task      | access object          | operator info                      |
+-------------------------+------------+-----------+------------------------+------------------------------------+
| TableReader_9           | 1026683.00 | root      |                        | data:Selection_8                   |
| └─Selection_8           | 1026683.00 | cop[tikv] |                        | ge(test.t1.x, 1), le(test.t1.x, 4) |
|   └─TableFullScan_7     | 1310720.00 | cop[tikv] | table:t1, ~!@partition:p0@!~ | keep order:false                   |
+-------------------------+------------+-----------+------------------------+------------------------------------+
3 rows in set (0.00 sec)
```

------------------------------------------------------

```
CREATE TABLE test.t1 (x INT) PARTITION BY RANGE (x) (
    partition p0 VALUES LESS THAN (5),
    partition p1 VALUES LESS THAN (10));
```