问我应该在这里创建任何索引来优化查询吗？

EN

SELECT bw.workloadId, lrer.lecturerId, lrer.lastname, lrer.name, lrer.fathername, bt.title, ac.activityname, cast(bw.exactday as char(45)) as "date", bw.exacttime as "time" FROM base_workload as bw
        right join unioncourse as uc on uc.idunioncourse = bw.idunioncourse
        right join basecoursea as bc on bc.idbasecoursea = uc.idbasecourse
        right join lecturer as lrer on lrer.lecturerId = uc.lecturerId
        right join basetitle as bt on bt.idbasetitle = bc.idbasetitle
        right join activity as ac on ac.activityId = bc.activityId
        where lrer.lecturerId is not null AND bc.idbasecoursea is not null and bw.idunioncourse != ""
        ORDER BY bw.exactday, bw.exacttime ASC;