sql如下:SELECT A.ASSEDT,A.OBJSID,B.ACCTID,A.RELART,A.ACCTFG
FROM FDM_PAMS_OUT_ACCT_TMP1 A , ODS.DCAM_DPAC B
WHERE (CASE WHEN A.ACCTNO=B.ACCTNO THEN B.ACCTNO ELSE B.ACCTID END)=A.ACCTNO AND B.ACCTDT=TO_DATE('20111231','YYYYMMDD')执行计划(用explain plan for):
1 Plan hash value: 1941993489
2
3 ---------------------------------------------------------------------------------------------------------------------------------------------
4 | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | TQ |IN-OUT| PQ Distrib |
5 ---------------------------------------------------------------------------------------------------------------------------------------------
6 | 0 | SELECT STATEMENT | | 13M| 1304M| 642M (1)|999:59:59 | | | | | |
7 | 1 | PX COORDINATOR | | | | | | | | | | |
8 | 2 | PX SEND QC (RANDOM) | :TQ10000 | 13M| 1304M| 642M (1)|999:59:59 | | | Q1,00 | P->S | QC (RAND) |
9 | 3 | NESTED LOOPS | | 13M| 1304M| 642M (1)|999:59:59 | | | Q1,00 | PCWP | |
10 | 4 | PX BLOCK ITERATOR | | 5982K| 233M| 7276 (1)| 00:01:28 | 1 | 2 | Q1,00 | PCWC | |
11 |* 5 | TABLE ACCESS FULL| DCAM_DPAC | 5982K| 233M| 7276 (1)| 00:01:28 | 1 | 2 | Q1,00 | PCWP | |
12 |* 6 | TABLE ACCESS FULL | FDM_PAMS_OUT_ACCT_TMP1 | 2 | 118 | 773 (1)| 00:00:10 | | | Q1,00 | PCWP | |
13 ---------------------------------------------------------------------------------------------------------------------------------------------
14
15 Predicate Information (identified by operation id):
16 ---------------------------------------------------
17
18 5 - filter("B"."ACCTDT"=TO_DATE(' 2011-12-31 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))
19 6 - filter("A"."ACCTNO"=CASE "A"."ACCTNO" WHEN "B"."ACCTNO" THEN "B"."ACCTNO" ELSE "B"."ACCTID" END )
FROM FDM_PAMS_OUT_ACCT_TMP1 A , ODS.DCAM_DPAC B
WHERE (CASE WHEN A.ACCTNO=B.ACCTNO THEN B.ACCTNO ELSE B.ACCTID END)=A.ACCTNO AND B.ACCTDT=TO_DATE('20111231','YYYYMMDD')执行计划(用explain plan for):
1 Plan hash value: 1941993489
2
3 ---------------------------------------------------------------------------------------------------------------------------------------------
4 | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | TQ |IN-OUT| PQ Distrib |
5 ---------------------------------------------------------------------------------------------------------------------------------------------
6 | 0 | SELECT STATEMENT | | 13M| 1304M| 642M (1)|999:59:59 | | | | | |
7 | 1 | PX COORDINATOR | | | | | | | | | | |
8 | 2 | PX SEND QC (RANDOM) | :TQ10000 | 13M| 1304M| 642M (1)|999:59:59 | | | Q1,00 | P->S | QC (RAND) |
9 | 3 | NESTED LOOPS | | 13M| 1304M| 642M (1)|999:59:59 | | | Q1,00 | PCWP | |
10 | 4 | PX BLOCK ITERATOR | | 5982K| 233M| 7276 (1)| 00:01:28 | 1 | 2 | Q1,00 | PCWC | |
11 |* 5 | TABLE ACCESS FULL| DCAM_DPAC | 5982K| 233M| 7276 (1)| 00:01:28 | 1 | 2 | Q1,00 | PCWP | |
12 |* 6 | TABLE ACCESS FULL | FDM_PAMS_OUT_ACCT_TMP1 | 2 | 118 | 773 (1)| 00:00:10 | | | Q1,00 | PCWP | |
13 ---------------------------------------------------------------------------------------------------------------------------------------------
14
15 Predicate Information (identified by operation id):
16 ---------------------------------------------------
17
18 5 - filter("B"."ACCTDT"=TO_DATE(' 2011-12-31 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))
19 6 - filter("A"."ACCTNO"=CASE "A"."ACCTNO" WHEN "B"."ACCTNO" THEN "B"."ACCTNO" ELSE "B"."ACCTID" END )
解决方案 »
- oralce 客户端连接成功,但是vb+ado连接失败,好像是oracle连接驱动有问题,怎么办?
- 求助ORACLE恢复
- 求数据库(pl/sql)的面试题
- sql 顺序问题 排序问题
- Oracle 事务概念理解问题
- 帮忙解决一个ORACLE查询问题(急),谢谢
- 为什么无法启动OracleTNSListener80服务??
- 请给我以指导
- please say the meaning of this code in your TEST_LIST_ITEM!! thank you(develper/2000)
- 三问存储过程中,临时表的建立问题?
- 外键未加索引
- the password will expire within 10 days
,然后再将第5部的行源返回给第4部呢?????还有TQ 什么意思呢?官网说是:table quque number 这个是什么东东呢????