explain plan for
SELECT A.EXAM_YR, A.INDEX_NO, C.LANG_MED_CD, C.SUBJ_CD, E.ALPHA_GRADE, E.NUM_GRADE
FROM XE_RP_CDDT_REG A, XE_EXAM_GRADES B, XE_SUBJ_CONFIGURATION C, XE_EXAM_CONFIGURATION D, XE_GRADE_CD E
WHERE A.EXAM_YR = 2007 AND A.EXAM_LVL_CD='PSLE' AND (A.REG_ST<>'W' AND A.REG_ST<>'U') AND A.EXAM_SERIES_CD='YE'
AND A.EXAM_YR=B.EXAM_YR AND A.EXAM_LVL_CD=B.EXAM_LVL_CD AND A.INDEX_NO=B.INDEX_NO AND A.EXAM_SERIES_CD='YE'
AND A.EXAM_YR=C.EXAM_YR AND A.EXAM_LVL_CD=C.EXAM_LVL_CD AND A.EXAM_SERIES_CD=C.EXAM_SERIES_CD
AND C.EXAM_YR=D.EXAM_YR AND C.EXAM_LVL_CD=D.EXAM_LVL_CD AND C.EXAM_SERIES_CD=D.EXAM_SERIES_CD
AND C.SUBJ_ID=D.SUBJ_ID AND B.EXAM_CAT_KEY=D.EXAM_CAT_KEY
AND D.EXAM_YR=E.EXAM_YR AND D.GRADE_GRP_CD=E.GRADE_GRP_CD AND B.GRADE_CD=E.GRADE_CD
select * from plan_table
sql效率
最新推荐文章于 2021-11-10 11:44:31 发布