explain plan for select *
from
(SELECT
20131223 AS DATA_DATE,
NVL(T1.ACCT_NO, T2.ACCT_NO) AS ACCT_NO,
NVL(T1.ACCT_ORD, T2.ACCT_ORD) AS ACCT_ORD,
NVL(T1.ACCT_NO_PK, T2.ACCT_NO_PK) AS ACCT_NO_PK,
NVL(T1.ACCT_BAL, 0) AS ACCT_BAL,
NVL(T1.D_CMP_BAL, T2.D_CMP_BAL) AS D_CMP_BAL,
NVL(T1.M_CMP_BAL, T2.M_CMP_BAL) AS M_CMP_BAL,
NVL(T1.Y_CMP_BAL, T2.Y_CMP_BAL) AS Y_CMP_BAL,
NVL(T1.FLAG, T2.FLAG) AS FLAG,
NVL(T1.ACCT_FLAG, T2.ACCT_FLAG) AS ACCT_FLAG,
NVL(T1.TERM, T2.TERM) AS TERM,
NVL(T1.TERM_FLAG, T2.TERM_FLAG) AS TERM_FLAG,
NVL(T1.CUR_CODE, T2.CUR_CODE) AS CUR_CODE,
NVL(T1.CUR_NAME, T2.CUR_NAME) AS CU