sql语句性能优化

SELECT A.ID, A.TR_EmpID, A.TR_EmpCode, A.TR_EmpName, A.TR_EmpNumber, A.TR_CourseID, A.TR_CourseCode, A.TR_CourseName, A.TR_CourseValidDateStr, A.TR_CourseValidDate,A.TR_ID, TR_Code, A.TR_Name, A.TR_StartDate, A.TR_EndDate, A.TR_Content, A.TR_OrgName, A.TR_Mode, A.TR_Category, A.TR_SumCourseTime, A.TR_Score, A.TR_Result,A.TR_TechersName, A.TR_HasReatTR, A.TR_DepID, A.TR_DepName, A.TR_RecordSource, A.TR_RecordDate, A.TR_RecordStatus, A.TEACHERTYPE, A.isdeleted,B.JOINCOMPANTTIME,B.OUTCOMPANTTIME,B.EMPSTATUS,B.STATUSNAME,TE.ID AS TEID FROM View_TRAINNING_RECORD A  JOIN View_Employee B ON  A.TR_EmpID=B.EMPLOYEEID LEFT JOIN dbo.TRAINNING_EMPS TE ON  A.TR_ID=TE.TR_ID AND A.TR_EmpID=TE.TR_EMPID SELECT A.ID, A.TR_EmpID, A.TR_EmpCode, A.TR_Emp