# Check Index Regions

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

------------------------------------------------------------
Check Index Regions
In TiDB databases, the balanced distribution of data is very important because index data is organized in the order of key values. Therefore, it is very important to understand the distribution of index data. We can grasp the region distribution of a specific index of a specific table with the following statement
```
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 |
+-----------+-----------------------------------------+-----------------------------------------+-----------+-----------------+-------+------------+---------------+------------+----------------------+------------------+
```
