权限狗si全家7 权限狗si全家7
关注数: 1 粉丝数: 25 发帖数: 2,163 关注贴吧数: 13
我想请教个索引问题 这个sql语句该怎么加索引让它查询效率高? SELECT (@rowno :=@rowno + 1) AS rowno,SS.* from (SELECT @rowno := 0) AS it, (SELECT s.rname, s.nid, s.type, s.bir, s.category, s.foremanname, s.birthdate, s.pos, s.pic, s.project_name, s.startTimetxt, s.leftTimeTxt, s.remark, s.pid, s.aid, s.enid, s.subid, s.`name`, s.subcontractors, s.city_live FROM ( SELECT l.rname, l.nid, l.type, l.bir, l.pic, l.birthdate, l.pos, l.category, l.foremanname, p.project_name, a.startTimetxt, a.leftTimeTxt, a.startTime, a.leftTime, a.laborpersonId, a.managerpersonId, a.supervisorpersonId, a.remark, p.location_engineering, p.id pid, p.sqsbid, a.id aid, en.`name`, en.id enid, sub.subcontractors, sub.id subid, p.location_engineering as city_live FROM subcontractinfo sub RIGHT JOIN attendance a ON a.subcontractinfoId = sub.id JOIN project_schedule p ON a.project_scheduleId = p.id JOIN enterprise en ON p.enterpriseId = en.id LEFT JOIN ( SELECT DISTINCT l.laborName AS rname, l.laborNumberID AS nid, l.laborPersonnelType AS type, l.laborBirthdate AS birthdate, l.laborBirthplace AS bir, l.laborOccupation AS pos, l.laborPicture pic, l.laborForemanName AS foremanname, l.laborCategory AS category, l.project_scheduleId AS psId, l.subcontractinfoId AS sid FROM laborperson l UNION ALL SELECT DISTINCT b.managerName AS rname, b.managerNumberID AS nid, b.managerPersonnelType AS type, b.managerBirthdate AS birthdate, b.managerBirthplace AS bir, b.managerPosition AS pos, b.managerPicture pic, b.managerName AS foremanname, b.managerCategory AS category, b.project_scheduleId AS psId, b.subcontractinfoId AS sid FROM managerperson b UNION ALL SELECT DISTINCT c.supervisorName AS rname, c.supervisorNumberID AS nid, c.supervisorPersonnelType AS type, c.supervisorBirthdate AS birthdate, c.supervisorBirthplace AS bir, c.supervisorPosition AS pos, c.supervisorPicture pic, c.supervisorName AS foremanname, c.supervisorCategory AS category, c.project_scheduleId AS psId, c.subcontractinfoId AS sid FROM supervisorperson c ) l ON l.nid = a.numberID AND ( l.psId = a.project_scheduleId OR a.subcontractinfoId = l.sid ) ) s GROUP BY s.aid ORDER BY s.startTime DESC ) ss;
首页 1 2 3 下一页