执行计划
来源：互联网 发布：有机化学软件 编辑：程序博客网 时间：2024/04/27 21:39
SQL> set time on
16:27:35 SQL> set autotrace traceonly
16:27:45 SQL> select distinct a.*,b.creationTime,b.actId,b.businessid,a.arch_no || '[' || a.year || ']' || a.record_no || '号' as arch_no1
16:27:56 2 from app_2.v_app_work_list b,
16:27:56 3 (select a.*,v.action_name,v.action_operator from(select t.businessid,t.actname as action_name,strcat(d.user_realname) as action_operator from app_2.v_app_work_list t, app_2.td_sm_user d where t.username = d.user_name group by t.businessid, t.actname) v, app_2.ta_arch_rec a where v.businessid(+) = a.cc_form_instanceid ) a
16:27:56 4 where b.username = 'zhouyuehong' and b.ec_name = '收文' and a.cc_form_instanceid = b.businessid
16:27:56 5 order by b.creationTime desc;
已选择69行。
执行计划
----------------------------------------------------------
Plan hash value: 804153442
--------------------------------------------------------------------------------
---------------------------------------
| Id | Operation | Name |
Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------------
---------------------------------------
| 0 | SELECT STATEMENT | |
1 | 3152 | 230 (8)| 00:00:03 |
| 1 | FAST DUAL | |
1 | | 2 (0)| 00:00:01 |
| 2 | SORT AGGREGATE | |
1 | 35 | | |
|* 3 | TABLE ACCESS FULL | TD_PROC_FORM_INSTANCEMAP |
1 | 35 | 13 (0)| 00:00:01 |
| 4 | SORT UNIQUE | |
1 | 3152 | 229 (8)| 00:00:03 |
|* 5 | FILTER | |
| | | |
|* 6 | HASH JOIN | |
3 | 9456 | 213 (8)| 00:00:03 |
|* 7 | HASH JOIN OUTER | |
1 | 3125 | 190 (7)| 00:00:03 |
| 8 | MERGE JOIN CARTESIAN | |
1 | 1062 | 91 (6)| 00:00:02 |
| 9 | NESTED LOOPS | |
1 | 524 | 84 (5)| 00:00:02 |
| 10 | NESTED LOOPS | |
1 | 490 | 83 (5)| 00:00:02 |
|* 11 | HASH JOIN RIGHT ANTI | |
1 | 324 | 69 (5)| 00:00:01 |
| 12 | TABLE ACCESS FULL | TD_WORKLIST_TOBE |
541 | 28673 | 6 (0)| 00:00:01 |
| 13 | NESTED LOOPS | |
248 | 67208 | 63 (5)| 00:00:01 |
|* 14 | HASH JOIN | |
248 | 60016 | 62 (4)| 00:00:01 |
| 15 | NESTED LOOPS | |
248 | 32736 | 53 (4)| 00:00:01 |
|* 16 | HASH JOIN | |
268 | 28140 | 51 (2)| 00:00:01 |
|* 17 | TABLE ACCESS FULL | ASSIGNMENTSTABLE |
314 | 5338 | 9 (0)| 00:00:01 |
|* 18 | TABLE ACCESS FULL | ACTIVITIES |
251 | 22088 | 42 (3)| 00:00:01 |
| 19 | FAST DUAL | |
1 | | 2 (0)| 00:00:01 |
|* 20 | TABLE ACCESS BY INDEX ROWID | ACTIVITYSTATES |
1 | 27 | 1 (0)| 00:00:01 |
|* 21 | INDEX UNIQUE SCAN | ACTIVITYSTATES_OID |
1 | | 0 (0)| 00:00:01 |
| 22 | TABLE ACCESS FULL | PROCESSES |
1756 | 188K| 9 (0)| 00:00:01 |
|* 23 | INDEX UNIQUE SCAN | I1_PROCESSDEFINITIONS |
1 | 29 | 0 (0)| 00:00:01 |
|* 24 | VIEW | |
1 | 166 | 14 (8)| 00:00:01 |
| 25 | SORT GROUP BY | |
1760 | 122K| 14 (8)| 00:00:01 |
| 26 | TABLE ACCESS FULL | TD_PROC_FORM_INSTANCEMAP |
1760 | 122K| 13 (0)| 00:00:01 |
|* 27 | TABLE ACCESS BY INDEX ROWID | TB_FORM_CLASS |
1 | 34 | 1 (0)| 00:00:01 |
|* 28 | INDEX UNIQUE SCAN | PK_TB_FORM_CLASS |
1 | | 0 (0)| 00:00:01 |
| 29 | BUFFER SORT | |
181 | 97378 | 90 (6)| 00:00:02 |
| 30 | TABLE ACCESS FULL | TA_ARCH_REC |
181 | 97378 | 6 (0)| 00:00:01 |
| 31 | VIEW | |
2 | 4126 | 99 (9)| 00:00:02 |
| 32 | SORT GROUP BY | |
2 | 180 | 99 (9)| 00:00:02 |
| 33 | NESTED LOOPS | |
2 | 180 | 98 (8)| 00:00:02 |
| 34 | VIEW | V_APP_WORK_LIST |
3 | 216 | 95 (8)| 00:00:02 |
| 35 | SORT ORDER BY | |
3 | 3897 | 95 (8)| 00:00:02 |
|* 36 | HASH JOIN | |
3 | 3897 | 92 (7)| 00:00:02 |
| 37 | NESTED LOOPS | |
1 | 635 | 69 (5)| 00:00:01 |
| 38 | NESTED LOOPS | |
1 | 601 | 68 (5)| 00:00:01 |
| 39 | NESTED LOOPS | |
1 | 333 | 54 (4)| 00:00:01 |
| 40 | NESTED LOOPS | |
1 | 304 | 54 (4)| 00:00:01 |
| 41 | NESTED LOOPS | |
1 | 194 | 53 (4)| 00:00:01 |
|* 42 | HASH JOIN ANTI | |
1 | 177 | 51 (4)| 00:00:01 |
|* 43 | HASH JOIN | |
233 | 28892 | 44 (3)| 00:00:01 |
|* 44 | TABLE ACCESS FULL | ACTIVITYSTATES |
7 | 189 | 2 (0)| 00:00:01 |
|* 45 | TABLE ACCESS FULL | ACTIVITIES |
251 | 24347 | 42 (3)| 00:00:01 |
| 46 | FAST DUAL | |
1 | | 2 (0)| 00:00:01 |
| 47 | TABLE ACCESS FULL | TD_WORKLIST_TOBE |
541 | 28673 | 6 (0)| 00:00:01 |
| 48 | TABLE ACCESS BY INDEX ROWID| ASSIGNMENTSTABLE |
1 | 17 | 2 (0)| 00:00:01 |
|* 49 | INDEX RANGE SCAN | I2_ASSIGNMENTSTABLE |
1 | | 1 (0)| 00:00:01 |
| 50 | TABLE ACCESS BY INDEX ROWID | PROCESSES |
1 | 110 | 1 (0)| 00:00:01 |
|* 51 | INDEX UNIQUE SCAN | PROCESSES_OID |
1 | | 0 (0)| 00:00:01 |
|* 52 | INDEX UNIQUE SCAN | I1_PROCESSDEFINITIONS |
1 | 29 | 0 (0)| 00:00:01 |
|* 53 | VIEW | |
1 | 268 | 14 (8)| 00:00:01 |
| 54 | SORT GROUP BY | |
1760 | 122K| 14 (8)| 00:00:01 |
| 55 | TABLE ACCESS FULL | TD_PROC_FORM_INSTANCEMAP |
1760 | 122K| 13 (0)| 00:00:01 |
|* 56 | TABLE ACCESS BY INDEX ROWID | TB_FORM_CLASS |
1 | 34 | 1 (0)| 00:00:01 |
|* 57 | INDEX UNIQUE SCAN | PK_TB_FORM_CLASS |
1 | | 0 (0)| 00:00:01 |
| 58 | VIEW | V_APP_BUSINESS_LIST |
1572 | 1019K| 22 (10)| 00:00:01 |
| 59 | SORT UNIQUE | |
1572 | 135K| 22 (73)| 00:00:01 |
| 60 | UNION-ALL | |
| | | |
| 61 | TABLE ACCESS FULL | TA_ARCH_REC |
181 | 14480 | 6 (0)| 00:00:01 |
| 62 | TABLE ACCESS FULL | TA_ARCH_DESP |
1391 | 120K| 14 (0)| 00:00:01 |
| 63 | TABLE ACCESS BY INDEX ROWID | TD_SM_USER |
1 | 18 | 1 (0)| 00:00:01 |
|* 64 | INDEX UNIQUE SCAN | IDX_TD_SM_USER_UNAME |
1 | | 0 (0)| 00:00:01 |
| 65 | VIEW | V_APP_BUSINESS_LIST |
1572 | 42444 | 22 (10)| 00:00:01 |
| 66 | SORT UNIQUE | |
1572 | 135K| 22 (73)| 00:00:01 |
| 67 | UNION-ALL | |
| | | |
| 68 | TABLE ACCESS FULL | TA_ARCH_REC |
181 | 14480 | 6 (0)| 00:00:01 |
| 69 | TABLE ACCESS FULL | TA_ARCH_DESP |
1391 | 120K| 14 (0)| 00:00:01 |
| 70 | SORT AGGREGATE | |
1 | 35 | | |
|* 71 | TABLE ACCESS FULL | TD_PROC_FORM_INSTANCEMAP |
1 | 35 | 13 (0)| 00:00:01 |
--------------------------------------------------------------------------------
---------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
3 - filter("T"."PROCINSTANCEID"=:B1)
5 - filter("A"."CC_FORM_INSTANCEID"=CASE WHEN ("M"."BUSINESSID" IS NOT NULL)
THEN "M"."BUSINESSID" ELSE
(SELECT MAX("T"."BUSINESSID") FROM "DZZWPT"."TD_PROC_FORM_INSTANCE
MAP" "T" WHERE "T"."PROCINSTANCEID"=:B1) END
)
6 - access("X"."CC_FORM_INSTANCEID"="M"."BUSINESSID")
7 - access("V"."BUSINESSID"(+)="A"."CC_FORM_INSTANCEID")
11 - access("A"."ID"="T"."ACT_INS_ID")
14 - access("A"."PROCESS"="B"."OID")
16 - access("C"."ACTIVITY"="A"."OID")
17 - filter("C"."RESOURCEID"='zhouyuehong')
18 - filter("A"."LIMITTIME">TO_NUMBER( (SELECT TO_CHAR((SYSDATE@!-TO_DATE('197
0-01-01 00:00:00', 'yyyy-mm-dd
hh24:mi:ss')-.3333333333333333333333333333333333333333)*24*60*60*1
000,'999999999999999') FROM "SYS"."DUAL"
"DUAL")))
20 - filter("ACTIVITYSTATES"."KEYVALUE"<>'open.not_running.suspended')
21 - access("ACTIVITYSTATES"."OID"="A"."STATE")
23 - access("B"."PDEFNAME"="D"."NAME")
24 - filter("B"."ID"="M"."PROCINSTANCEID" OR "B"."ACTIVITYREQUESTERPROCESSID"=
"M"."PROCINSTANCEID" AND
"B"."ACTIVITYREQUESTERPROCESSID" IS NOT NULL)
27 - filter("C"."EC_NAME"='收文' AND "C"."APP_ID"='2')
28 - access("M"."EC_ID"="C"."EC_ID")
36 - access("X"."CC_FORM_INSTANCEID"="M"."BUSINESSID")
42 - access("A"."ID"="T"."ACT_INS_ID")
43 - access("ACTIVITYSTATES"."OID"="A"."STATE")
44 - filter("ACTIVITYSTATES"."KEYVALUE"<>'open.not_running.suspended')
45 - filter("A"."LIMITTIME">TO_NUMBER( (SELECT TO_CHAR((SYSDATE@!-TO_DATE('197
0-01-01 00:00:00', 'yyyy-mm-dd
hh24:mi:ss')-.3333333333333333333333333333333333333333)*24*60*60*1
000,'999999999999999') FROM "SYS"."DUAL"
"DUAL")))
49 - access("C"."ACTIVITY"="A"."OID")
51 - access("A"."PROCESS"="B"."OID")
52 - access("B"."PDEFNAME"="D"."NAME")
53 - filter("B"."ID"="M"."PROCINSTANCEID" OR "B"."ACTIVITYREQUESTERPROCESSID"=
"M"."PROCINSTANCEID" AND
"B"."ACTIVITYREQUESTERPROCESSID" IS NOT NULL)
56 - filter("C"."APP_ID"='2')
57 - access("M"."EC_ID"="C"."EC_ID")
64 - access("T"."USERNAME"="D"."USER_NAME")
71 - filter("T"."PROCINSTANCEID"=:B1)
Note
-----
- 'PLAN_TABLE' is old version
统计信息
----------------------------------------------------------
2771 recursive calls
0 db block gets
14092 consistent gets
0 physical reads
0 redo size
33251 bytes sent via SQL*Net to client
429 bytes received via SQL*Net from client
6 SQL*Net roundtrips to/from client
103 sorts (memory)
0 sorts (disk)
69 rows processed
16:28:01 SQL> spool off
- 执行计划
- 计划、执行
- 执行计划
- 执行计划
- 计划，，，执行
- 执行计划
- 执行计划
- 执行计划
- 执行计划
- 执行计划
- 执行计划
- 执行计划
- 执行计划
- 执行计划
- 执行计划
- 执行计划
- 执行计划执行顺序
- 执行计划和执行顺序
- php加密技术
- 企业的员工座谈会
- Drawable、byte[]、Bitmap、Canvas和Paint的关系和转换
- jquery autocomplete 使用
- Android入门开发经验
- 执行计划
- ADOdb介绍
- SCROLLINFO结构的使用
- Session过期时间的四种设置方式
- 经典SQL语句大全
- Qt 中文显示
- Android高手进阶教程(六)之 ----Android 中MenuInflater的使用(布局定义菜单)
- ADOdb类库及其简单应用
- 初学Smarty
