【MySQL数据库高级】索引两表优化案例

建表：


案例：

EXPLAIN SELECT * FROM class c LEFT JOIN book b ON c.`card` = b.`card`;

右表建立索引：

CREATE INDEX id_card ON book(card);
EXPLAIN SELECT * FROM class c LEFT JOIN book b ON c.`card` = b.`card`;

删除索引：

DROP INDEX id_card ON book;

左表建立索引：

CREATE INDEX id_card ON class(card);

EXPLAIN SELECT * FROM class c LEFT JOIN book b ON c.`card` = b.`card`;

---

左连接：特性决定，left join条件用于确定从右边搜索行，左边一定有，所以右边是关键点，一定要建立索引