涉及到的表如下
DD07T 40多万
JEST 5千多万
ANEK 4百多万
ANEP 1千8百多万
PRPS 8百多万
PROJ 40多万
ANLA 7百多万
sql语句如下
select count(*) from (select DISTINCT a.PSPID, a.post1, a.PSPNR from PROJ a LEFT join JEST b on a.OBJNR = b.OBJNR ) a inner join PRPS c on a.PSPNR = c.PSPHI inner join DD07T d on d.DOMNAME = 'ZDFMIS' and d.DOMVALUE_L = c.ZZFMIS inner join ANLA e on c.PSPNR = e.POSNR inner join ANEP f on f.ANLN1 = e.ANLN1 and f.BUKRS = e.BUKRS inner join ANEK g on f.BUKRS = g.BUKRS and f.ANLN1 = g.ANLN1;
如何在以上各表创建索引 ,可以优化查询