EXPLAIN PLAN FOR

EXPLAIN PLAN FOR
SELECT /*+ rule */LECTNO,
       USERID,
       nvl(round(SUM(DECODE(HIGH_OBJ_SEQ, 0, CNT, 1))/ decode(1, 0, 1, 1)*100), 0) LECT_PROGRESS_AVG
FROM   (SELECT /*+ ordered  */A.LECTNO,
               A.USERID,
               D.HIGH_OBJ_SEQ,
               COUNT(*) CNT
        FROM   MR_LECTURE_MEMBER A,
               MR_LECTURE_COURSE B,
               LCMS_ORGANIZATION C,
               LCMS_COURSE_ITEM D,
               SM4_OBJECTINFO E
        WHERE  A.LECTNO = 53122
        and    A.LMSTATECD = '9'
        AND    B.LECTNO = A.LECTNO
        AND    C.COURSE_SEQ = B.COURSENO
        AND    C.ORG_CD = B.ORG_CD
        AND    D.COURSE_SEQ = C.COURSE_SEQ
        AND    D.ORG_CD = C.ORG_CD
        AND    D.ORG_SEQ = C.ORG_SEQ
        AND    E.OBJ_SEQ = D.OBJ_SEQ
        AND    E.LEARNER_ID = A.USERID
        AND    E.completion_status = 'completed'
        AND    D.ITEM_OPEN = 'true'
        AND    D.HIGH_OBJ_SEQ >= 0
        GROUP BY A.LECTNO, A.USERID, HIGH_OBJ_SEQ) AA
GROUP BY LECTNO, USERID;;

SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);;