# 举例

+ 非聚簇表 - 创建非聚簇表 User
+ ID 列为主键列，非聚簇列
+ 插入 3 行数据
```
...
PRIMARY KEY ~!@NONClustered@!~,
...
Insert into User values ( 100, "TiDB", "SQL Layer", 10 );
Insert into User values ( 200, "TiKV", "KV Engine", 20 );
Insert into User values ( 300, "PD", "Manager", 30 );
t10_i1_100 --> 1
t10_i1_200 --> 2
t10_i1_300 --> 3
```

-------------------------------------------------------------
假设 TiDB 中存储了一个 user 表

```
CREATE TABLE User (
    ID int not null PRIMARY KEY NONClustered,
    Name varchar(20),
    Role varchar(20),
    Age int,
    KEY idxAge (Age)
);
```

插入了 3 行数据
```
100, "TiDB", "SQL Layer", 10
200, "TiKV", "KV Engine", 20
300, "PD", "Manager", 30
```

数据的 KV 映射关系
```
t10_r1 --> [100, "TiDB", "SQL Layer", 10]
t10_r2 --> [200, "TiKV", "KV Engine", 20]
t10_r3 --> [300, "PD", "Manager", 30]
```

主键的 KV 映射关系
```
t10_i1_100 --> 1
t10_i1_200 --> 2
t10_i1_300 --> 3
```


二级索引的 KV 映射关系
```
t10_i2_10_1 --> null
t10_i2_20_2 --> null
t10_i2_30_3 --> null
```