EXPLAIN
SELECT b.ID AS ruku_id, b.ComID,b.PotClass,b.area as outin_area,a.Updata,a.ID AS q_id,a.BJID,a.ProName,a.Buysl,a.Buyer,a.BuyerID,a.Units,
a.InDepotState,a.State,a.shadd,b.Updata AS indate,b.ProUser,b.Addmen,b.DepotNo,b.price,b.Quantity,b.Amount,a.ExpenseID
FROM sean_depot_outin_detail b
LEFT JOIN sean_depot1_need a ON b.SeanLoo_Depot1_Need_ID = a.ID
WHERE a.shadd=1401
#WHERE a.shadd=b.ComID
shadd和comID 都建了索引,为什么“WHERE a.shadd=1401“用到了索引,如下:
但是“WHERE a.shadd=b.ComID”没用到索引?