SQL语句:
SELECT /*+parallel(t1 16)*/
T1.DATA_DATE,
T1.ACCT_NO,
T1.ACCT_ORD,
T1.ACCT_NO_PK,
T1.ACCT_BAL,
T1.D_CMP_BAL,
T1.M_CMP_BAL,
T1.Y_CMP_BAL,
T1.FLAG,
T1.ACCT_FLAG,
T1.TERM,
T1.TERM_FLAG,
T1.CUR_CODE,
NVL(T5.CUR_NAME, T1.CUR_NAME) AS CUR_NAME,
T1.SUB_CODE,
T1.CUST_NO,
T1.CUST_TYPE,
NVL(T3.CUST_NAME, T1.CUST_NAME) AS CUST_NAME,
T1.BANK_CORP_CODE,
NVL(T4.BRAN_NAME, T1.BRAN_NAME) AS BRAN_NAME,
T1.MGR_CODE,
T1.MGR_NAME,
T1.OPEN_DATE,
T1.FIX_BAL,
T1.DIV_FIX_FLAG,
T1.ADJUST_AMT,
T1.ADJUST_AMT_AF,
T1.Y_AVG_AF,
T1.Y_ADD_AF,
T1.ACCT_INTR,
T1.SIM_PROFIT,
T1.SEPA_POR,
T1.PRI,
T1.BRAN_CODE,
T1.UNIT1_CODE,
T1.UNIT2_CODE,
T1.UNIT3_CODE,
T1.UNIT4_CODE,
NVL(T6.UNIT5_CODE, T1.UNIT5_CODE) AS UNIT5_CODE,
NVL(T6.DEPT1_CODE, T1.DEPT1_CODE) AS DEPT1_CODE,
T1.INTR_RATE,
T1.DUE_DATE
FROM (SELECT /*&
并行HASH JOIN小表广播问题
最新推荐文章于 2022-11-12 16:30:19 发布
本文深入分析了在并行处理环境中,如何有效地处理HASH JOIN操作中的小表广播问题。讨论了不同广播策略对性能的影响,包括内存消耗、计算效率和并行度的优化。通过对各种策略的比较,揭示了选择合适广播策略的重要性,以实现更高效的数据库查询执行。
摘要由CSDN通过智能技术生成