Mysql

From Sum-e Wiki

explain query

explain select * from product join category on product.category = category.id;

add table index

alter table product add index category_idx ( category );

alter table product_category add index category_product_idx ( category, product ); // to be confirmed / tested