1 select
2 a.*
3 from (select
4 ssi.ID,
5 'small_station_info' TB,
6 (select sbi.name
7 from scene_base_info sbi
8 where sbi.id = ssi.antenna_selection) as antenna_selection,
9 ssi.antenna_height,
10 ssi.down_angle,
11 ssi.azimuth_angle,
12 ssi.ITI_ID,
13 sa.longitude,
14 sa.latitude,
15 sa.attach_id
16 from consolidation_demand cd
17 left join demand_test_info dti
18 on cd.id = dti.cd_id
19 left join demand_plan_info dpi
20 on dti.id = dpi.tdl_id
21 left join building_plan_info bpi
22 on dpi.id = bpi.dpi_id
23 left join NEAR_FAR_PLACE_INFO nfpi
24 on bpi.id = nfpi.bpi_id
25 left join SMALL_STATION_INFO ssi
26 on nfpi.id = ssi.nfpi_id
27 left join site_attachment sa
28 on TO_NUMBER(sa.longitude) is not null
29 AND TO_NUMBER(sa.latitude) > 26.074423
30 AND TO_NUMBER(sa.latitude) < 26.077573
31 AND TO_NUMBER(sa.longitude) > 119.191148
32 AND TO_NUMBER(sa.longitude) < 119.197649
33 AND sa.attach_name =
34 substr(ssi.AZIMUTH_ANGLE_PHOTO,
35 instr(ssi.AZIMUTH_ANGLE_PHOTO, '/', -1) + 1,
36 length(ssi.AZIMUTH_ANGLE_PHOTO))) a
37 where a.longitude is not null
已选择 12 行。
执行计划
----------------------------------------------------------
Plan hash value: 1917963167
---------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
---------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 253 | 519 (2)| 00:00:07 |
| 1 | TABLE ACCESS BY INDEX ROWID | SCENE_BASE_INFO | 1 | 14 | 1 (0)| 00:00:01 |
|* 2 | INDEX UNIQUE SCAN | SCENE_BASE_INFO_PK | 1 | | 0 (0)| 00:00:01 |
| 3 | VIEW | | 1 | 253 | 519 (2)| 00:00:07 |
|* 4 | FILTER | | | | | |
|* 5 | HASH JOIN OUTER | | 1 | 251 | 519 (2)| 00:00:07 |
|* 6 | HASH JOIN OUTER | | 83 | 8134 | 505 (1)| 00:00:07 |
|* 7 | HASH JOIN OUTER | | 83 | 7304 | 501 (1)| 00:00:07 |
|* 8 | HASH JOIN OUTER | | 83 | 6391 | 493 (1)| 00:00:06 |
|* 9 | HASH JOIN OUTER | | 83 | 5478 | 271 (1)| 00:00:04 |
| 10 | MERGE JOIN CARTESIAN | | 36 | 2052 | 21 (0)| 00:00:01 |
|* 11 | TABLE ACCESS BY INDEX ROWID| SITE_ATTACHMENT | 1 | 53 | 16 (0)| 00:00:01 |
|* 12 | INDEX RANGE SCAN | IDX_SITE_ATTACHMENT_JWD | 1 | | 15 (0)| 00:00:01 |
| 13 | BUFFER SORT | | 6725 | 26900 | 5 (0)| 00:00:01 |
| 14 | INDEX FAST FULL SCAN | PK_CONSOLIDATION_DEMAND | 6725 | 26900 | 5 (0)| 00:00:01 |
| 15 | TABLE ACCESS FULL | DEMAND_TEST_INFO | 15459 | 135K| 249 (1)| 00:00:03 |
| 16 | TABLE ACCESS FULL | DEMAND_PLAN_INFO | 8787 | 96657 | 221 (1)| 00:00:03 |
| 17 | TABLE ACCESS FULL | BUILDING_PLAN_INFO | 3244 | 35684 | 8 (0)| 00:00:01 |
| 18 | TABLE ACCESS FULL | NEAR_FAR_PLACE_INFO | 389 | 3890 | 3 (0)| 00:00:01 |
| 19 | TABLE ACCESS FULL | SMALL_STATION_INFO | 594 | 90882 | 13 (0)| 00:00:01 |
---------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("SBI"."ID"=:B1)
4 - filter("SA"."ATTACH_NAME"=SUBSTR("SSI"."AZIMUTH_ANGLE_PHOTO",INSTR("SSI"."AZIMUTH_ANGLE_PHOTO",'
/',-1)+1,LENGTH("SSI"."AZIMUTH_ANGLE_PHOTO")))
5 - access("NFPI"."ID"="SSI"."NFPI_