# 查看索引的 Region 分布

`SHOW TABLE [table_name] INDEX [index_name] REGIONS [WhereClauseOptional];`

-------------------------------------------------------------
查看索引的 Region 分布
在 TiDB 中数据库中，数据的均衡分布是非常重要的，由于索引数据是按照键值的顺序进行组织的。所以掌握索引数据的分布情况是一件非常重要的事情。我们可以通过如下语句掌握特定 Table 的特定索引的 Region 分布情况
```
SHOW TABLE [table_name] INDEX [index_name] REGIONS [WhereClauseOptional];

SHOW TABLE t1 index idx_t1_b REGIONS;
+-----------+-----------------------------------------+-----------------------------------------+-----------+-----------------+-------+------------+---------------+------------+----------------------+------------------+
| REGION_ID | START_KEY                | END_KEY                 | LEADER_ID | LEADER_STORE_ID | PEERS | SCATTERING | WRITTEN_BYTES | READ_BYTES | APPROXIMATE_SIZE(MB) | APPROXIMATE_KEYS |
+-----------+-----------------------------------------+-----------------------------------------+-----------+-----------------+-------+------------+---------------+------------+----------------------+------------------+
|    59 | t_53_                  | t_53_i_1_0380000000000000fa030000000000 |    60 |        1 | 60  |     0 |     1323 |     0 |          4 |      29032 |
|    61 | t_53_i_1_0380000000000000fa030000000000 | t_53_i_1_0380000000000001f4030000000000 |    62 |        1 | 62  |     0 |     1323 |     0 |          2 |        0 |
|    63 | t_53_i_1_0380000000000001f4030000000000 | t_53_i_1_0380000000000002ee030000000000 |    64 |        1 | 64  |     0 |     1323 |     0 |          8 |      116401 |
|    65 | t_53_i_1_0380000000000002ee030000000000 | t_53_i_2_                |    66 |        1 | 66  |     0 |      27 |     0 |          12 |      146948 |
+-----------+-----------------------------------------+-----------------------------------------+-----------+-----------------+-------+------------+---------------+------------+----------------------+------------------+
```