SQL 语句执行时间过长
各位大佬,请帮忙检查下SQL哪里有问题。非常感谢!!
增加最后一张表的执行时间是 7s, 不关联最后一张表的执行时间是 0.6s, 相差 10 倍
最后一张表的数据量是:1.2w
SELECT Bus_TransferData.*,Bus_TransferData.F_Unit AS F_UnitId
FROM Bus_TransferData
INNER JOIN Bus_TransferInfo ON Bus_TransferInfo.F_Id=Bus_TransferData.F_TransferId
LEFT JOIN Bus_DesignTask ON Bus_TransferData.F_TaskId=Bus_DesignTask.F_Id
LEFT JOIN Bus_Project ON Bus_Project.F_Id=Bus_TransferData.F_ProjectId
LEFT JOIN bus_projectbom ON Bus_DesignTask.F_BomId=bus_projectbom.F_Id
LEFT JOIN Bus_PartInfo ON Bus_TransferData.F_PartId=Bus_PartInfo.F_Id
LEFT JOIN Bus_PartInfo g ON Bus_TransferData.F_EquipmentId=g.F_Id
LEFT JOIN bus_rawinfo_test ON Bus_TransferData.F_RawId = bus_rawinfo_test.F_Id