确认执行计划中分区号对应的分区

scan724

于 2013-12-27 11:33:57 发布

阅读量699

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库维护

本文链接：https://blog.youkuaiyun.com/zhaoyangjian724/article/details/17608539

数据库维护专栏收录该内容

109 篇文章 ¥39.90 ¥99.00

订阅专栏

本文详细介绍了如何在SQL查询执行计划中确认所操作的数据分区，这对于理解和优化数据库性能至关重要。通过理解分区号及其对应关系，可以更有效地进行大数据处理和查询优化。

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

了解本专栏