单表: select a from t FORCE INDEX(idx_name) WHERE name = ‘小明’
连表:select * from t1 LEFT JOIN t2 FORCE INDEX(t2_idx_name) on t1.id = t2.t1_id
mysql使用强制索引
最新推荐文章于 2023-09-26 17:19:37 发布
单表: select a from t FORCE INDEX(idx_name) WHERE name = ‘小明’
连表:select * from t1 LEFT JOIN t2 FORCE INDEX(t2_idx_name) on t1.id = t2.t1_id