MySql（十六）--索引三表优化

在上一篇的基础上

添加表

create table if not exists `phone`(
 `phoneid` INT(10) unsigned NOT NULL  auto_increment,
 `card` INT(10) unsigned NOT NULL,
 primary key(`phoneid`)
)ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

insert into phone(card) values(floor(1+(RAND()*20)));
insert into phone(card) values(floor(1+(RAND()*20)));
insert into phone(card) values(floor(1+(RAND()*20)));
insert into phone(card) values(floor(1+(RAND()*20)));
insert into phone(card) values(floor(1+(RAND()*20)));
insert into phone(card) values(floor(1+(RAND()*20)));
insert into phone(card) values(floor(1+(RAND()*20)));
insert into phone(card) values(floor(1+(RAND()*20)));
insert into phone(card) values(floor(1+(RAND()*20)));
insert into phone(card) values(floor(1+(RAND()*20)));
insert into phone(card) values(floor(1+(RAND()*20)));
insert into phone(card) values(floor(1+(RAND()*20)));
insert into phone(card) values(floor(1+(RAND()*20)));
insert into phone(card) values(floor(1+(RAND()*20)));
insert into phone(card) values(floor(1+(RAND()*20)));
insert into phone(card) values(floor(1+(RAND()*20)));
insert into phone(card) values(floor(1+(RAND()*20)));
insert into phone(card) values(floor(1+(RAND()*20)));
insert into phone(card) values(floor(1+(RAND()*20)));
insert into phone(card) values(floor(1+(RAND()*20)));
insert into phone(card) values(floor(1+(RAND()*20)));

没建立索引

添加两个索引

alter table book add index y (card);
alter table phone add index z (card);