查询性能优化。。。。
from JSHX_EM_StkRecordLine srl
left join JSHX_EM_StkRecord sr on srl.cHeadGUID=sr.cGUID
left join CM_Material cm on srl.cMatGUID=cm.cGUID
left join CM_Unit cu on srl.cUnitGUID = cu.cGUID
left join CM_Unit cMu ON srl.cMUnitGUID = cMu.cGUID
left join JSHX_EM_Area ea on srl.cMatArea=ea.cGUID
left join ST_MatPosition mp on srl.cGUID = mp.cStkLineID
left join cm_customer cc on sr.cCustGUID =cc.cGUID
where
iAuditStatus='1' and
srl.iOutQTY<srl.iQTY and
sr.cBusType='04001' and
cStkOutLineStatus='0' and
sr.cCustGUID ='533411669541064724' and
sr.cStoreGUID = '533411669541001619'
红色是固定条件
蓝色是动态
如何优化 查询 目前五六万属于 查询需要十几秒 求高手支招
若建立索引如何建立。