• A shot in the writing

The data table

class book

Case 1

Left connection

explain select * from book b left join class c on b.card = c.card;
Copy the code

Indexes are built on slave tables. The primary table must be scanned for all tables.

Three table

  • using join buffer

Small tables drive large tables