Plan hash value: 3171350582
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows |E-Bytes| Cost (%CPU)| E-Time | A-Rows | A-Time | Buffers | Reads | OMem | 1Mem | Used-Mem |
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 1 | TABLE ACCESS BY INDEX ROWID | KH_KHDD | 1 | 1 | 22 | 3 (0)| 00:00:01 | 1 |00:00:00.01 | 4 | 0 | | | |
|* 2 | INDEX UNIQUE SCAN | SYS_C008867 | 1 | 1 | | 2 (0)| 00:00:01 | 1 |00:00:00.01 | 3 | 0 | | | |
| 3 | SORT AGGREGATE | | 1 | 1 | 13 | | | 1 |00:00:00.01 | 4 | 2 | | | |
|* 4 | TABLE ACCESS BY INDEX ROWID | TICKET_RETURNRECORD | 1 | 1 | 13 | 2 (0)| 00:00:01 | 1 |00:00:00.01 | 4 | 2 | | | |
|* 5 | INDEX RANGE SCAN | IDX_RETURN_TK | 1 | 1 | | 1 (0)| 00:00:01 | 1 |00:00:00.01 | 2 | 1 | | | |
|* 6 | COUNT STOPKEY | | 1 | | | | | 1 |00:00:00.01 | 4 | 0 | | | |
|* 7 | TABLE ACCESS BY INDEX ROWID | TICKET_RETURNRECORD | 1 | 1 | 15 | 2 (0)| 00:00:01 | 1 |00:00:00.01 | 4 | 0 | | | |
|* 8 | INDEX RANGE SCAN | IDX_RETURN_TK | 1 | 1 | | 1 (0)| 00:00:01 | 1 |00:00:00.01 | 2 | 0 | | | |
|* 9 | COUNT STOPKEY | | 1 | | | | | 1 |00:00:00.01 | 4 | 0 | | | |
|* 10 | TABLE ACCESS BY INDEX ROWID | TICKET_RETURNRECORD | 1 | 1 | 15 | 2 (0)| 00:00:01 | 1 |00:00:00.01 | 4 | 0 | | | |
|* 11 | INDEX RANGE SCAN | IDX_RETURN_TK | 1 | 1 | | 1 (0)| 00:00:01 | 1 |00:00:00.01 | 2 | 0 | | | |
| 12 | TABLE ACCESS BY INDEX ROWID | B_ZC_BXXZ | 1 | 1 | 22 | 1 (0)| 00:00:01 | 1 |00:00:00.01 | 6 | 0 | | | |
|* 13 | INDEX UNIQUE SCAN | SYS_C006844 | 1 | 1 | | 0 (0)| | 1 |00:00:00.01 | 5 | 0 | | | |
|* 14 | COUNT STOPKEY | | 1 | | | | | 1 |00:00:00.01 | 4 | 0 | | | |
| 15 | TABLE ACCESS BY INDEX ROWID | KH_KHDD | 1 | 1 | 39 | 3 (0)| 00:00:01 | 1 |00:00:00.01 | 4 | 0 | | | |
|* 16 | INDEX UNIQUE SCAN | SYS_C008867 | 1 | 1 | | 2 (0)| 00:00:01 | 1 |00:00:00.01 | 3 | 0 | | | |
|* 17 | COUNT STOPKEY | | 1 | | | | | 1 |00:00:00.01 | 4 | 1 | | | |
| 18 | TABLE ACCESS BY INDEX ROWID | KH_KHDD | 1 | 1 | 26 | 4 (0)| 00:00:01 | 1 |00:00:00.01 | 4 | 1 | | | |
|* 19 | INDEX RANGE SCAN | KHDD_PNR | 1 | 1 | | 3 (0)| 00:00:01 | 1 |00:00:00.01 | 3 | 1 | | | |
|* 20 | COUNT STOPKEY | | 1 | | | | | 1 |00:00:00.01 | 4 | 0 | | | |
| 21 | TABLE ACCESS BY INDEX ROWID | KH_KHDDCJR | 1 | 1 | 24 | 3 (0)| 00:00:01 | 1 |00:00:00.01 | 4 | 0 | | | |
|* 22 | INDEX UNIQUE SCAN | SYS_C008878 | 1 | 1 | | 2 (0)| 00:00:01 | 1 |00:00:00.01 | 3 | 0 | | | |
|* 23 | COUNT STOPKEY | | 1 | | | | | 1 |00:00:00.01 | 4 | 0 | | | |
| 24 | TABLE ACCESS BY INDEX ROWID | KH_KHDDCJR | 1 | 1 | 24 | 3 (0)| 00:00:01 | 1 |00:00:00.01 | 4 | 0 | | | |
|* 25 | INDEX UNIQUE SCAN | SYS_C008878 | 1 | 1 | | 2 (0)| 00:00:01 | 1 |00:00:00.01 | 3 | 0 | | | |
|* 26 | COUNT STOPKEY | | 1 | | | | | 1 |00:00:00.01 | 4 | 0 | | | |
|* 27 | TABLE ACCESS BY INDEX ROWID | TICKET_RETURNRECORD | 1 | 1 | 32 | 2 (0)| 00:00:01 | 1 |00:00:00.01 | 4 | 0 | | | |
|* 28 | INDEX RANGE SCAN | IDX_RETURN_TK | 1 | 1 | | 1 (0)| 00:00:01 | 1 |00:00:00.01 | 2 | 0 | | | |
| 29 | SORT AGGREGATE | | 1 | 1 | 55 | | | 1 |00:00:00.01 | 6 | 3 | | | |
| 30 | NESTED LOOPS | | 1 | 1 | 55 | 3 (0)| 00:00:01 | 1 |00:00:00.01 | 6 | 3 | | | |
| 31 | TABLE ACCESS BY INDEX ROWID | T_GQSQB_MX | 1 | 1 | 34 | 2 (0)| 00:00:01 | 1 |00:00:00.01 | 3 | 1 | | | |
|* 32 | INDEX RANGE SCAN | IDX_T_GQSQB_MX_TKNO | 1 | 1 | | 1 (0)| 00:00:01 | 1 |00:00:00.01 | 2 | 0 | | | |
|* 33 | TABLE ACCESS BY INDEX ROWID | T_GQSQB | 1 | 1 | 21 | 1 (0)| 00:00:01 | 1 |00:00:00.01 | 3 | 2 | | | |
|* 34 | INDEX UNIQUE SCAN | PK_T_GQSQB | 1 | 1 | | 0 (0)| | 1 |00:00:00.01 | 2 | 1 | | | |
| 35 | SORT AGGREGATE | | 1 | 1 | 55 | | | 1 |00:00:00.01 | 6 | 0 | | | |
| 36 | NESTED LOOPS | | 1 | 1 | 55 | 3 (0)| 00:00:01 | 1 |00:00:00.01 | 6 | 0 | | | |
| 37 | TABLE ACCESS BY INDEX ROWID | T_GQSQB_MX | 1 | 1 | 34 | 2 (0)| 00:00:01 | 1 |00:00:00.01 | 3 | 0 | | | |
|* 38 | INDEX RANGE SCAN | IDX_T_GQSQB_MX_TKNO | 1 | 1 | | 1 (0)| 00:00:01 | 1 |00:00:00.01 | 2 | 0 | | | |
|* 39 | TABLE ACCESS BY INDEX ROWID | T_GQSQB | 1 | 1 | 21 | 1 (0)| 00:00:01 | 1 |00:00:00.01 | 3 | 0 | | | |
|* 40 | INDEX UNIQUE SCAN | PK_T_GQSQB | 1 | 1 | | 0 (0)| | 1 |00:00:00.01 | 2 | 0 | | | |
|* 41 | TABLE ACCESS BY INDEX ROWID | TICKET_ALL | 1 | 1 | 56 | 3 (0)| 00:00:01 | 0 |00:00:00.01 | 4 | 0 | | | |
|* 42 | INDEX UNIQUE SCAN | SYS_C0011742 | 1 | 1 | | 2 (0)| 00:00:01 | 1 |00:00:00.01 | 3 | 0 | | | |
|* 43 | INDEX RANGE SCAN | IDX_TICKZF3 | 1 | 1 | 19 | 3 (0)| 00:00:01 | 0 |00:00:00.01 | 3 | 1 | | | |
| 44 | SORT ORDER BY | | 1 | 1 | 828 | 37 (6)| 00:00:01 | 1 |00:01:16.68 | 139K| 49999 | 4096 | 4096 | 4096 (0)|
|* 45 | HASH JOIN SEMI | | 1 | 1 | 828 | 36 (3)| 00:00:01 | 1 |00:01:16.63 | 139K| 49991 | 683K| 683K| 376K (0)|
| 46 | NESTED LOOPS | | 1 | 1 | 823 | 32 (0)| 00:00:01 | 1 |00:01:16.63 | 139K| 49991 | | | |
| 47 | NESTED LOOPS OUTER | | 1 | 1 | 821 | 8 (0)| 00:00:01 | 1 |00:01:16.60 | 139K| 49988 | | | |
| 48 | NESTED LOOPS OUTER | | 1 | 1 | 791 | 6 (0)| 00:00:01 | 1 |00:01:16.59 | 139K| 49986 | | | |
|* 49 | TABLE ACCESS BY INDEX ROWID | TICKET_ALL | 1 | 1 | 765 | 4 (0)| 00:00:01 | 1 |00:01:16.58 | 139K| 49984 | | | |
|* 50 | INDEX RANGE SCAN | IDX_DP_DATETIME | 1 | 2 | | 3 (0)| 00:00:01 | 457K|00:00:08.31 | 4756 | 3095 | | | |
| 51 | TABLE ACCESS BY INDEX ROWID | KH_KHDDCJR | 1 | 1 | 26 | 2 (0)| 00:00:01 | 1 |00:00:00.01 | 4 | 2 | | | |
|* 52 | INDEX UNIQUE SCAN | SYS_C008878 | 1 | 1 | | 1 (0)| 00:00:01 | 1 |00:00:00.01 | 3 | 1 | | | |
| 53 | TABLE ACCESS BY INDEX ROWID | TICKET_EXTEND | 1 | 1 | 30 | 2 (0)| 00:00:01 | 1 |00:00:00.01 | 4 | 2 | | | |
|* 54 | INDEX UNIQUE SCAN | SYS_C0011880 | 1 | 1 | | 1 (0)| 00:00:01 | 1 |00:00:00.01 | 3 | 1 | | | |
| 55 | COLLECTION ITERATOR PICKLER FETCH | TICKJE | 1 | | | | | 1 |00:00:00.03 | 64 | 3 | | | |
| 56 | VIEW | VW_NSO_1 | 1 | 7 | 35 | 3 (0)| 00:00:01 | 1 |00:00:00.01 | 7 | 0 | | | |
|* 57 | CONNECT BY NO FILTERING WITH START-WITH| | 1 | | | | | 1 |00:00:00.01 | 7 | 0 | | | |
| 58 | TABLE ACCESS FULL | VE_COMP | 1 | 7 | 77 | 3 (0)| 00:00:01 | 7 |00:00:00.01 | 7 | 0 | | | |
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------