目录
1创建表
create table dev.user2222(id varchar primary key,name varchar,age varchar,phone varchar,email varchar);
select * from dev.user2222;
upsert into dev.user2222 values('1001','caocao','26','13800000000','caocao@163.com');
upsert into dev.user2222 values('1002','liubei','24','13800000001','liubei@163.com');
upsert into dev.user2222 values('1003','guanyu','23','13800000002','guanyu@163.com');
upsert into dev.user2222 values('1004','zhangfei','22','13800000003','zhangfei@163.com');
upsert into dev.user2222 values('1005','sunquan','20','13800000004','sunquan@163.com');
2.查看数据
explain select * from dev.user2222;
3.创建索引
3.1索引类型1
create index index_name_user2222 ON dev.USER2222(name);
走索引
explain select name from dev.user2222 where name='caocao';
explain select name from dev.user2222 where name='caocao' order by name limit 2 offset 22;
不走索引
explain select * from dev.user2222 where name='caocao' order by name limit 2 offset 22;
explain select name from dev.user2222 where name='caocao';
3.2索引类型2
create index index_name_full_user2222 ON dev.USER2222(name) INCLUDE(id,age,phone,email);
走索引
explain select * from dev.user2222 where name='caocao' order by name limit 2 offset 22;