select a.ata_id,a.ata_tat_id, b.gush_num, b.gush_suffix,b.parcel,b.status
FROM gis_atar1 a, gis_parcel1 b WHERE sde.ST_Intersects(b.shape,
sde.ST_Buffer(a.shape,0)) =1 and a.ata_id=567
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.26 0.25 0 1297 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.03 0.06 1 38 0 26
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.29 0.32 1 1335 0 26
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 100
Number of plan statistics captured: 1
select a.ata_id,a.ata_tat_id, b.gush_num, b.gush_suffix,b.parcel,b.status
FROM gis_atar1 a, gis_parcel1 b WHERE sde.ST_Intersects(b.shape,
sde.ST_Buffer(a.shape,0)) =1 and a.ata_id=567
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.03 0.05 0 38 0 26
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.03 0.05 0 38 0 26
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 100
Number of plan statistics captured: 1
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Plan hash value: 3387874830
--------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 8564 | 21M| 4 (0)| 00:00:01 |
| 1 | NESTED LOOPS | | 8564 | 21M| 4 (0)| 00:00:01 |
| 2 | TABLE ACCESS BY INDEX ROWID | GIS_ATAR1 | 1 | 240 | 2 (0)| 00:00:01 |
|* 3 | INDEX RANGE SCAN | GIS_ATAR1_ATA_IDX | 1 | | 1 (0)| 00:00:01 |
| 4 | TABLE ACCESS BY INDEX ROWID | GIS_PARCEL1 | 8348 | 18M| 4 (0)| 00:00:01 |
|* 5 | DOMAIN INDEX (Sel: Default - No Stats)| A11_IX1 | | | 18E (0)| |
--------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
3 - access("A"."ATA_ID"=567)
5 - access("SDE"."ST_INTERSECTS"("B"."SHAPE","SDE"."ST_BUFFER"("A"."SHAPE",0))=1)
Note
-----
- dynamic sampling used for this statement (level=2)
22 rows selected