摘要:
没靠加索引,纯sql优化,提速最快的,效果最好。WITH TEST AS(SELECT M1.FloderID,M1.ParentFloderID,M1.FloederName FROM MB_Favoriten M1 WHERE FloderID=0UNION ALL SELECT M2.FloderID,M2.ParentFloderID,M2.FloederName FROM MB_Favoriten M2 JOIN TEST ON M2.ParentFloderID=TEST.FloderID),A AS(SELECT A1.* FROM MB_Employment A1 INNER 阅读全文