|
楼主 |
发表于 2020-10-12 15:03:10
|
显示全部楼层
1.你说的是看SQL执行的时间吗,我已经知道SQL执行时间,知道哪句慢了,但如何解决呢
现在就是下面这句慢
SELECT SA_Task.sID AS SA_Task, SA_Task.SACTIVITY AS sActivity, SA_Task.SCREATETIME AS sCreateTime, SA_Task.SCREATORFNAME AS sCreatorFName, SA_Task.SDATA1 AS sData1, SA_Task.SDATA2 AS sData2, SA_Task.SDATA3 AS sData3, SA_Task.SDATA4 AS sData4, SA_Task.SEURL AS sEURL, SA_Task.SEXECUTORFID AS sExecutorFID, SA_Task.SEXECUTORFNAME AS sExecutorFName, SA_Task.SEXECUTORNAMES AS sExecutorNames, SA_Task.SKINDID AS sKindID, SA_Task.SNAME AS sName, SA_Task.SPROCESS AS sProcess, SA_Task.SSTATUSID AS sStatusID FROM SA_Task SA_Task WHERE ( (SA_Task.SSTATUSID = 'tesReady') OR (SA_Task.SSTATUSID = 'tesExecuting') ) AND ( '/ORG01.ogn/j2p0Q1ICDHWvnGpmopr.dpt/3IhRmfncK3iBxsmDegG@j2p0Q1ICDHWvnGpmopr.psm' LIKE concat_ws('',SA_Task.SEXECUTORFID, '%')) AND (SA_Task.SEXECUTORFID LIKE '/%') ORDER BY sCreateTime DESC
|
|