select count(1) a1 from kh_khdd d join kh_khdd_extend ex on d.ddbh = ex.ddbh join wd_zlsz wd on d.ct_hyid = wd.wdbh where 1 = 1 and d.ds_compid in (select
bh as column_value from ve_comp start with bh = 'CQLF' connect by prior bh = parbh) and
d.ds_datetime_date >= to_date('2015-08-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss') and d.ds_datetime_date <= to_date('2015-08-25 23:59:59', 'yyyy-mm-dd hh24:mi:ss') and
d.pnr_hcglgj = '1' and ex.wdzc_code like '%?%' and (exists (select 1 from t_pt_log where ddbh = d.ddbh and
ywlx = ' and by1 = '3') or (exists (select 1 from ticket_all where ddbh = d.ddbh) and (ex.htphsb is null and ex.mpnr_no is
not null))) and d.zkfx = '1' order by d.dp_datetime_date
Plan hash value: 1723379971
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows |E-Bytes| Cost (%CPU)| E-Time | A-Rows | A-Time | Buffers | Reads | OMem | 1Mem | Used-Mem |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 1 | SORT AGGREGATE | | 1 | 1 | 96 | | | 1 |00:00:52.19 | 10M| 9311 | | | |
|* 2 | FILTER | | 1 | | | | | 0 |00:00:52.19 | 10M| 9311 | | | |
| 3 | NESTED LOOPS | | 1 | 50 | 4800 | 3836 (1)| 00:00:47 | 0 |00:00:52.19 | 10M| 9311 | | | |
| 4 | NESTED LOOPS | | 1 | 50 | 3050 | 3736 (1)| 00:00:45 | 138K|00:00:50.07 | 9714K| 0 | | | |
| 5 | MERGE JOIN CARTESIAN | | 1 | 9 | 108 | 78 (0)| 00:00:01 | 175 |00:00:00.01 | 15 | 0 | | | |
| 6 | TABLE ACCESS FULL | WD_ZLSZ | 1 | 25 | 125 | 3 (0)| 00:00:01 | 25 |00:00:00.01 | 7 | 0 | | | |
| 7 | BUFFER SORT | | 25 | 9 | 63 | 0 (0)| | 175 |00:00:00.01 | 8 | 0 | 73728 | 73728 | |
| 8 | VIEW | VW_NSO_1 | 1 | 9 | 63 | 3 (0)| 00:00:01 | 7 |00:00:00.01 | 8 | 0 | | | |
| 9 | HASH UNIQUE | | 1 | 9 | 99 | | | 7 |00:00:00.01 | 8 | 0 | | | |
|* 10 | FILTER | | 1 | | | | | 7 |00:00:00.01 | 8 | 0 | | | |
|* 11 | CONNECT BY WITH FILTERING | | 1 | | | | | 7 |00:00:00.01 | 8 | 0 | 9216 | 9216 | 8192 (0)|
| 12 | TABLE ACCESS BY INDEX ROWID| VE_COMP | 1 | | | | | 1 |00:00:00.01 | 2 | 0 | | | |
|* 13 | INDEX UNIQUE SCAN | SYS_C00129518 | 1 | 1 | 6 | 0 (0)| | 1 |00:00:00.01 | 1 | 0 | | | |
|* 14 | HASH JOIN | | 2 | | | | | 6 |00:00:00.01 | 6 | 0 | 1396K| 1396K| 832K (0)|
| 15 | CONNECT BY PUMP | | 2 | | | | | 7 |00:00:00.01 | 0 | 0 | | | |
| 16 | TABLE ACCESS FULL | VE_COMP | 2 | 9 | 99 | 3 (0)| 00:00:01 | 18 |00:00:00.01 | 6 | 0 | | | |
| 17 | TABLE ACCESS FULL | VE_COMP | 0 | 9 | 99 | 3 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 18 | TABLE ACCESS BY INDEX ROWID | KH_KHDD | 175 | 6 | 294 | 406 (0)| 00:00:05 | 138K|00:00:50.04 | 9714K| 0 | | | |
|* 19 | INDEX RANGE SCAN | IDX_CT_HYID | 175 | 629 | | 3 (0)| 00:00:01 | 14M|00:00:01.83 | 48892 | 0 | | | |
|* 20 | TABLE ACCESS BY INDEX ROWID | KH_KHDD_EXTEND | 138K| 1 | 35 | 2 (0)| 00:00:01 | 0 |00:00:02.00 | 420K| 9311 | | | |
|* 21 | INDEX UNIQUE SCAN | SYS_C00129801 | 138K| 1 | | 1 (0)| 00:00:01 | 138K|00:00:01.23 | 276K| 1804 | | | |
|* 22 | TABLE ACCESS BY INDEX ROWID | T_PT_LOG | 0 | 1 | 32 | 7 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 23 | INDEX RANGE SCAN | IDX_PT_LOG | 0 | 4 | | 3 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 24 | INDEX RANGE SCAN | IDX_DDBH | 0 | 4 | 76 | 3 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------