CESS BY INDEX ROWID | GG_FUNCTION_LOCATION | 1 | 36 | 1 (0)| 00:00:01 |
|* 29 | INDEX UNIQUE SCAN | PK_GG_FUNCTION_LOCATION | 1 | | 0 (0)| 00:00:01 |
|* 30 | INDEX RANGE SCAN | IDX_TECH_OBJECT_ID1 | 1 | | 2 (0)| 00:00:01 |
| 31 | HASH UNIQUE | | 1 | 339 | 20 (5)| 00:00:01 |
| 32 | TABLE ACCESS BY INDEX ROWID | GG_TECH_OBJECT_NODE | 1 | 103 | 3 (0)| 00:00:01 |
| 33 | NESTED LOOPS | | 1 | 339 | 19 (0)| 00:00:01 |
| 34 | NESTED LOOPS SEMI | | 1 | 236 | 16 (0)| 00:00:01 |
| 35 | NESTED LOOPS | | 1 | 226 | 14 (0)| 00:00:01 |
| 36 | NESTED LOOPS | | 1 | 133 | 13 (0)| 00:00:01 |
| 37 | NESTED LOOPS | | 3 | 291 | 10 (0)| 00:00:01 |
| 38 | VIEW | | 3 | 21 | 6 (0)| 00:00:01 |
|* 39 | FILTER | | | | | |
|* 40 | CONNECT BY WITH FILTERING | | | | | |
| 41 | TABLE ACCESS BY INDEX ROWID | GG_TECH_OBJECT_NODE | | | | |
|* 42 | INDEX RANGE SCAN | IDX_TECH_OBJECT_ID1 | 1 | 7 | 3 (0)| 00:00:01 |
| 43 | NESTED LOOPS | | | | | |
| 44 | BUFFER SORT | | | | | |
| 45 | CONNECT BY PUMP | | | | | |
| 46 | TABLE ACCESS BY INDEX ROWID | GG_TECH_OBJECT_NODE | 3 | 72 | 6 (0)| 00:00:01 |
|* 47 | INDEX RANGE SCAN | IDX_TECH_OBJECT_PARENT_ID1 | 3 | | 3 (0)| 00:00:01 |
|* 48 | TABLE ACCESS FULL | GG_TECH_OBJECT_NODE | 3 | 72 | 6 (0)| 00:00:01 |
|* 49 | TABLE ACCESS BY INDEX ROWID | GG_DEVICE | 1 | 90 | 2 (0)| 00:00:01 |
|* 50 | INDEX UNIQUE SCAN | PK_GG_DEVICE | 1 | | 1 (0)| 00:00:01 |
|* 51 | TABLE ACCESS BY INDEX ROWID | GG_FUNCTION_LOCATION | 1 | 36 | 1 (0)| 00:00:01 |
|* 52 | INDEX UNIQUE SCAN | PK_GG_FUNCTION_LOCATION | 1 | | 0 (0)| 00:00:01 |
|* 53 | TABLE ACCESS BY INDEX ROWID | GG_CLASSIFY_CARD | 1 | 93 | 1 (0)| 00:00:01 |
|* 54 | INDEX UNIQUE SCAN | SYS_C00468549 | 1 | | 0 (0)| 00:00:01 |
|* 55 | INDEX RANGE SCAN | IDX_TECH_NODE_ID1 | 587K| 5736K| 2 (0)| 00:00:01 |
|* 56 | INDEX RANGE SCAN | IDX_TECH_OBJECT_ID1 | 1 | | 2 (0)| 00:00:01 |
------------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
12 - filter("N"."NODE_TYPE"=2)
13 - filter("N"."TECH_OBJECT_ID"=15773325)
15 - access("N"."TECH_OBJECT_ID"=15773325)
20 - access("N"."PARENT_ID"=NULL)
21 - access("N"."PARENT_ID"=NULL)
22 - filter("D"."IS_SHARE_DEVICE"=1 AND "D"."CURRENT_STATUS"=0)
23 - access("TAB"."TECH_OBJECT_ID"="D"."DEVICE_ID")
24 - filter("C"."ALIAS_NAME"='A176')
25 - access("D"."CLASSIFY_ID"="C"."CLASSIFY_ID")
26 - access("N"."TECH_OBJECT_ID"="D"."DEVICE_ID" AND "N"."NODE_TYPE"=2)
27 - access("L"."DEVICE_ID"="D"."DEVICE_ID")
28 - filter("F"."SITE_ID"=1021)
29 - access("F"."FUNCTION_LOCATION_ID"="L"."FUNCTION_LOCATION_ID")
30 - access("N"."TECH_OBJECT_ID"="F"."FUNCTION_LOCATION_ID")
39 - filter("N"."NODE_TYPE"=2)
40 - filter("N"."TECH_OBJECT_ID"=15773325)
42 - access("N"."TECH_OBJECT_ID"=15773325)
47 - access("N"."PARENT_ID"=NULL)
48 - access("N"."PARENT_ID"=NULL)
49 - filter("D"."IS_SHARE_DEVICE"=0 AND "D"."CURRENT_STATUS"=0)
50 - access("TAB"."TECH_OBJECT_ID"="D"."DEVICE_ID")
51 - filter("F"."SITE_ID"=1021)
52 - access("F"."FUNCTION_LOCATION_ID"="D"."FUNCTION_LOCATION_ID")
53 - filter("C"."ALIAS_NAME"='A176')
54 - access("D"."CLASSIFY_ID"="C"."CLASSIFY_ID")
55 - access("N"."TECH_OBJECT_ID"="D"."DEVICE_ID" AND "N"."NODE_TYPE"=2)
56 - access("N"."TECH_OBJECT_ID"="F"."FUNCTION_LOCATION_ID")
统计信息
----------------------------------------------------------
7 recursive calls
0 db block gets
738 consistent gets
0 physical reads
0 redo siz |