mysql 散列查询_mysql-索引使用-列的散列度-01

mysql 查询优化中，索引的使用原则

前提：sys_user 。数据340W

CREATE TABLE `sys_user` (

`id` int(11) NOT NULL AUTO_INCREMENT ,

`user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名' ,

`user_password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户密码' ,

`phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话号码' ,

`email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱' ,

`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址' ,

PRIMARY KEY (`id`),

INDEX `idx_user_name` (`user_name`) USING BTREE

)

ENGINE=InnoDB

DEFAULT CHARACTER