INSERT
INTO SALE_CARD_BALANCE
(
ACCOUNT_ID,
CARD_NO,
CARD_SORT_ID,
CARD_TYPE,
CARD_TYPE_NAME,
SUMMONS_NO,
MANAGEDBRANCHNO,
MANAGEDBRANCHNAME,
SALE_DATE,
UNIT_NO,
NOW_BALANCE,
CREATE_DATE,
RUN_DATE,
CARD_STATE,
INIT_AMOUNT
)
SELECT
/+index(b IDX_ACCOUNT_ID)/
A.ACCOUNT_ID,
A.CARD_NO,
A.CARD_SOTR_ID,
A.CARD_TYPE,
A.CARD_TYPE_NAME,
A.SUMMONS_NO,
A.MANAGEDBRANCHNO,
A.MANAGEDBRANCHNAME,
A.OPT_DATE AS SALE_DATE,
A.UNIT_NO,
SUM(B.AMOUNT) AS NOW_BALANCE,
SYSDATE,
:B1 AS RUN_DATE,
B.STATUS,
A.INIT_AMOUNT
FROM SJL_CARD_BANK A
JOIN UNITED.XSH_VALID_CARD B
ON A.ACCOUNT_ID = B.ACCOUNT_ID
AND B.AMOUNT>0
WHERE A.SALE_SYS = ‘new’
AND A.DETAIL_TYPE != ‘废卡’
GROUP BY A.ACCOUNT_ID,
A.CARD_NO,
A.CARD_SOTR_ID,
A.CARD_TYPE,
A.CARD_TYPE_NAME,
A.SUMMONS_NO,
A.MANAGEDBRANCHNO,
A.MANAGEDBRANCHNAME,
A.OPT_DATE,
A.UNIT_NO,
A.DETAIL_TYPE,
B.STATUS,
A.ZERO_FLAG,
A.INIT_AMOUNT

添加强制走索引，效果还是不明显,此条sql谁能帮忙看看优化的地方。

执行计划：