mysql 视图查询问题 忘大神解答

Question

目前项目中有一个查询语句查询的是视图 而视图 是一个多表查询多表查询中有两个表的 之间左连接而且表数据量都超过十万

这是创建视图的 语句

select rqf.prcid AS prcid,rqf.rcid AS rqfrcid,rsf.rcid AS rsfrcid,rsf.remark AS remark,rqf.queryField AS queryField,rqf.flowid AS rqfflowid,rsf.flowid AS rsfflowid,rqf.status AS rqfstatus,rsf.status AS rsfstatus,rqf.rccrttm AS rqfrccrttm,rsf.rccrttm AS rsfrccrttm,rqfitf.interfaceCode AS rqfinterfaceCode,rsfitf.interfaceCode AS rsfinterfaceCode,rqftc.caseCode AS rqfcaseCode,rqftc.casedesc AS rqfcasedesc,rsftc.caseCode AS rsfcaseCode,rsf.content AS content,concat_ws('-',rqfitf.interfaceCode,rqfitf.insname) AS rqfinsname,concat_ws('-',rsfitf.interfaceCode,rsfitf.insname) AS rsfinsname,concat_ws('-',rqftc.caseCode,rqftc.caseName) AS rqfcaseName,concat_ws('-',rsftc.caseCode,rsftc.caseName) AS rsfcaseName,rqf.filePath AS rqffilepath,rsf.filePath AS rsffilepath from (((((requestflow rqf left join responseflow rsf on(((rsf.rfrcid = rqf.flowid) and (rsf.prcid = rqf.prcid)))) left join testcase rqftc on((rqf.crcid = rqftc.rcid))) left join interface rqfitf on((rqf.ircid = rqfitf.rcid))) left join testcase rsftc on((rsf.crcid = rsftc.rcid))) left join interface rsfitf on((rsf.ircid = rsfitf.rcid)))
下面是mysql 执行计划

Answer 1

你想表明什么问题呢？性能优化，还是其它的？