ROWID | GG_TECH_OBJECT_NODE | | | | |
|* 26 | INDEX RANGE SCAN | IDX_TECH_OBJECT_ID | 1 | 7 | 3 (0)| 00:00:01 |
|* 27 | HASH JOIN | | | | | |
| 28 | CONNECT BY PUMP | | | | | |
| 29 | TABLE ACCESS FULL | GG_TECH_OBJECT_NODE | 1762K| 40M| 9291 (1)| 00:01:52 |
| 30 | TABLE ACCESS FULL | GG_TECH_OBJECT_NODE | 1762K| 40M| 9291 (1)| 00:01:52 |
| 31 | HASH UNIQUE | | 12 | 4056 | 13804 (1)| 00:02:46 |
|* 32 | HASH JOIN | | 12 | 4056 | 13803 (1)| 00:02:46 |
| 33 | TABLE ACCESS BY INDEX ROWID | GG_TECH_OBJECT_NODE | 1 | 102 | 3 (0)| 00:00:01 |
| 34 | NESTED LOOPS | | 11 | 3641 | 4501 (1)| 00:00:55 |
| 35 | NESTED LOOPS SEMI | | 10 | 2290 | 4471 (1)| 00:00:54 |
|* 36 | HASH JOIN | | 10 | 2190 | 4451 (1)| 00:00:54 |
|* 37 | TABLE ACCESS FULL | GG_CLASSIFY_CARD | 1 | 93 | 16 (0)| 00:00:01 |
|* 38 | TABLE ACCESS BY INDEX ROWID| GG_DEVICE | 4 | 360 | 5 (0)| 00:00:01 |
| 39 | NESTED LOOPS | | 2823 | 347K| 4434 (1)| 00:00:54 |
|* 40 | TABLE ACCESS FULL | GG_FUNCTION_LOCATION | 685 | 24660 | 2214 (1)| 00:00:27 |
|* 41 | INDEX RANGE SCAN | IDX_FLOCID | 4 | | 2 (0)| 00:00:01 |
|* 42 | INDEX RANGE SCAN | IDX_TECH_NODE_ID | 482K| 4712K| 2 (0)| 00:00:01 |
|* 43 | INDEX RANGE SCAN | IDX_TECH_OBJECT_ID | 1 | | 2 (0)| 00:00:01 |
| 44 | VIEW | | 1762K| 11M| 9291 (1)| 00:01:52 |
|* 45 | FILTER | | | | | |
|* 46 | CONNECT BY WITH FILTERING | | | | | |
| 47 | TABLE ACCESS BY INDEX ROWID | GG_TECH_OBJECT_NODE | | | | |
|* 48 | INDEX RANGE SCAN | IDX_TECH_OBJECT_ID | 1 | 7 | 3 (0)| 00:00:01 |
|* 49 | HASH JOIN | | | | | |
| 50 | CONNECT BY PUMP | | | | | |
| 51 | TABLE ACCESS FULL | GG_TECH_OBJECT_NODE | 1762K| 40M| 9291 (1)| 00:01:52 |
| 52 | TABLE ACCESS FULL | GG_TECH_OBJECT_NODE | 1762K| 40M| 9291 (1)| 00:01:52 |
---------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - filter("AB"."RN">0)
2 - filter(ROWNUM<=25)
4 - filter(ROWNUM<=25)
8 - access("TAB"."TECH_OBJECT_ID"="D"."DEVICE_ID")
13 - access("L"."DEVICE_ID"="D"."DEVICE_ID")
14 - access("D"."CLASSIFY_ID"="C"."CLASSIFY_ID")
15 - filter("C"."ALIAS_NAME"='A176')
16 - filter("D"."IS_SHARE_DEVICE"=1 AND "D"."CURRENT_STATUS"=0)
18 - filter("F"."SITE_ID"=1021)
19 - access("F"."FUNCTION_LOCATION_ID"="L"."FUNCTION_LOCATION_ID")
20 - access("N"."TECH_OBJECT_ID"="D"."DEVICE_ID" AND "N"."NODE_TYPE"=2)
21 - access("N"."TECH_OBJECT_ID"="F"."FUNCTION_LOCATION_ID")
23 - filter("N"."NODE_TYPE"=2)
24 - filter("N"."TECH_OBJECT_ID"=15773325)
26 - access("N"."TECH_OBJECT_ID"=15773325)
27 - access("N"."PARENT_ID"=NULL)
32 - access("TAB"."TECH_OBJECT_ID"="D"."DEVICE_ID")
36 - access("D"."CLASSIFY_ID"="C"."CLASSIFY_ID")
37 - filter("C"."ALIAS_NAME"='A176')
38 - filter("D"."IS_SHARE_DEVICE"=0 AND "D"."CURRENT_STATUS"=0)
40 - filter("F"."SITE_ID"=1021)
41 - access("F"."FUNCTION_LOCATION_ID"="D"."FUNCTION_LOCATION_ID")
42 - access("N"."TECH_OBJECT_ID"="D"."DEVICE_ID" AND "N"."NODE_TYPE"=2)
43 - access("N"."TECH_OBJECT_ID"="F"."FUNCTION_LOCATION_ID")
45 - filter("N"."NODE_TYPE"=2)
46 - filter("N"."TECH_OBJECT_ID"=15773325)
48 - access("N"."TECH_OBJECT_ID"=15773325)
49 - access("N"."PARENT_ID"=NULL)
统计信息
----------------------------------------------------------
9 recursive calls
0 db block gets
209163 consistent gets
0 physical reads
0 redo size
2890 bytes sent via SQL*Net to client
10811 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from cl |