mysql添加索引

alter table ｀user｀ add unique（｀username｀）；

id,username,pwd,email,tel----1000人数据27min

对username添加索引前：

select username,pwd,email,tel from user where username='username';耗时：3.30s

对username添加索引后：

select username,pwd,email,tel from user where username='username';耗时：0.04s

 

 

alter table ｀user｀ add unique（｀email｀,`tel`）；耗时：1h9min47s

select username,pwd,email,tel from user where email='username@163.com';耗时：0.04s

 

mysql添加索引：http://www.jb51.net/article/32149.htm

 

转载于:https://www.cnblogs.com/lyFocus/p/6284223.html